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.

^ 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=Sheet2!A2)/(Sheet1!B:B=Sheet2!B2),Sheet1!C:C)

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,

PS. I have just sent you a "Message" via this site's internal system.

*Jagwarman*.PS. I have just sent you a "Message" via this site's internal system.