Jagwarman
asked on
Lookup 2 cells
Can an expert assist me with this lookup please.
I need to look up 'A' and 'B' on sheet 2 and return 'C' from sheet 1 [range is Data]
I have shown in the attached spreadsheet what the results should be for the first 3, i.e.
A GBP XYZ
B EUR XYZ
C CAD ABC
thank you
lookup-2-cells.xlsx
I need to look up 'A' and 'B' on sheet 2 and return 'C' from sheet 1 [range is Data]
I have shown in the attached spreadsheet what the results should be for the first 3, i.e.
A GBP XYZ
B EUR XYZ
C CAD ABC
thank you
lookup-2-cells.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
![Avatar of [ fanpages ]](https://filedb.experts-exchange.com/files/public/2020/2/28/4acbe344-900b-4e79-96ce-65fe58a6f004.png){kind=small}
^ That'll teach me not to provide extended instructions & screen images! :)
ASKER
They are all 'Best Solution' many thanks
Jagwarman,
in case if you do not want to use CONTROL SHIFT ENTER. then you can use this formula
=LOOKUP(2,1/(Sheet1!A:A=Sh
lookup-2-cells.xlsx
in case if you do not want to use CONTROL SHIFT ENTER. then you can use this formula
=LOOKUP(2,1/(Sheet1!A:A=Sh
lookup-2-cells.xlsx
Thanks for being fair with the points allocated, Jagwarman.
PS. I have just sent you a "Message" via this site's internal system.
PS. I have just sent you a "Message" via this site's internal system.