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

High and welcome
F159:F159 is one cell only? What are you trying to do?
( BTW using entire column/row references is not good practice)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

i attached the File - maybe that makes it clearer what i would like to achieve

As soon as the country in Colums A changes i have to reference to a different Numer.

everything that is green ist OK, but the Red ones are wrong

Attached Files

Sample.xlsx (184.7 KB, 3 views)

Sheet is protected...

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

reuploaded

Attached Files

Sample.xlsx (184.6 KB, 5 views)

Attached is what I came up with (pull down as needed)

Attached Files

Sample(6).xlsx (179.5 KB, 5 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

If I've properly understood what your looking to do, in D2, try:
copied down.
For the non-english version , open the attached.

Attached Files

msofficeforums51963Sample.xlsx (163.9 KB, 3 views)

Thank you both @Pecoflyer and @p45cal !

Both solution seem to work for now i only need to figure out how it works.

THANK YOU !!!