#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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)
__________________
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 |
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
Sheet is protected...
__________________
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 |
#5
|
|||
|
|||
reuploaded
|
#6
|
||||
|
||||
Attached is what I came up with (pull down as needed)
__________________
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 |
#7
|
||||
|
||||
If I've properly understood what your looking to do, in D2, try:
Code:
=INDEX(Tabelle2!$C$3:$BE$27,MATCH(A2,Tabelle2!$B$3:$B$27),IFERROR(MATCH(B2,Tabelle2!$C$2:$BE$2),1)) For the non-english version , open the attached. |
#8
|
|||
|
|||
Solved
Thank you both @Pecoflyer and @p45cal !
Both solution seem to work for now i only need to figure out how it works. THANK YOU !!! |
|
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 |