Forum Discussion
Solved
Excel formula
Hallo, I am trying to achieve the following:
I have an input form (table 1) where you can select texts using a drop down.
In another table (table 2) I have the same texts (Column K) and a column ...
In K8:
=IFERROR(VLOOKUP(L8, 'Sheet Name'!$K$107:$O$110, 5, FALSE), "")
In Dutch:
=ALS.FOUT(VERT.ZOEKEN(L8; 'Sheet Name'!$K$107:$O$110; 5; ONWAAR); "")
where Sheet Name is the sheet with the lookup table. If it is the same sheet, you can omit the part
'Sheet Name'!
Fill or copy down from K8 to K27.
In K8:
=IFERROR(VLOOKUP(L8, 'Sheet Name'!$K$107:$O$110, 5, FALSE), "")
In Dutch:
=ALS.FOUT(VERT.ZOEKEN(L8; 'Sheet Name'!$K$107:$O$110; 5; ONWAAR); "")
where Sheet Name is the sheet with the lookup table. If it is the same sheet, you can omit the part
'Sheet Name'!
Fill or copy down from K8 to K27.
