Forum Discussion
Solved
formula needed for VLOOKUP
Good evening, I am looking for an VLOOPUP formula or other formula, which check two base (BER and LEJ) from table in whole table on various columns and the dedicated price for the base from another s...
- Hi, is it possible to lookup for price only in column C, but to search in columns A and C, but exclude column B. Thx
A simple VLOOKUP / SVERWEIS will work.
Hi, is it possible to lookup for price only in column C, but to search in columns A and C, but exclude column B. Thx
I used
=IFERROR(VLOOKUP(A2&"-"&C2,'pax tax'!A:C,3,FALSE),0)
=WENNFEHLER(SVERWEIS(A2&"-"&C2;'pax tax'!A:C;3;FALSCH);0)
- Hi, can u pls send me formula. Should be like the one you send last time, but with the exclude. Thx