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
Hi, the figures are predefined.
In regards of BER SOF and price, the system has to check "BER" and "SOF". The BER is in EU as start and SOF as destination is also in EU and due to this comes to 45,10 eur.
For the BER HRG, the destination of HRG is not in EU as destination, and thatfore ex BER (start) the price for non EU is 55,10 eur.
Best regards
In regards of BER SOF and price, the system has to check "BER" and "SOF". The BER is in EU as start and SOF as destination is also in EU and due to this comes to 45,10 eur.
For the BER HRG, the destination of HRG is not in EU as destination, and thatfore ex BER (start) the price for non EU is 55,10 eur.
Best regards
How can the formula "know" that BER is in EU and LAX is not? I know that and you know that, but Excel doesn't. Both have EU and ex EU fees.
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
- 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.
HansVogelaar
Hi, i created an table with predefined routes and taxes for them.
Now it should work.
Thx