How to use a Field as part of a Formula

		Microsoft Office Forums > Microsoft Excel > Excel
How to use a Field as part of a Formula

FAQ

Thread Tools

Display Modes

01-26-2024, 12:26 AM

daOlli

Windows 10 How to use a Field as part of a Formula

Office 2021

Novice

Join Date: Jan 2024

Posts: 4

How to use a Field as part of a Formula

Hi Everyone,

i hope someone can help me. I would like to replace "4:4" with "F159:F159" in my formula:

F159 = "=VERGLEICH(A159;Tabelle2!B:B;0)" = 4

=WENNNV(INDEX(Tabelle2!4:4;VERGLEICH(B159;Tabelle2!$2:$2

);D160)

kind regards
Oliver

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA insert quick part formula and format as percentage	jeffreybrown	Word	3	03-12-2021 02:52 PM
Formula needed. If I write a specific name then I want the corresponding part number to fill	kmurph	Excel	1	11-28-2018 12:02 AM
Quick part building blocks - Formula	lukegwilson96	Word	6	12-13-2016 10:46 AM
How do you remove part of a formula	Macer	Excel Programming	2	09-24-2015 11:08 AM
Formula to subtract one month from due date field in reminder field	ghumdinger	Outlook	1	10-01-2011 12:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:32 PM.