Lookup with 2 criteria


M

mwear

How do I use what is in Sheets 1 and 2 to come up with the results in column
G on Sheet 1?? For G2, I want to lookup B2 in column A of sheet 2 and lookup
E2 in D1:F1 on sheet 2 and then return the value in D2.

Thanks in advance.


Sheet 1
A B C D E F G
1 Numbers Location Results
2 12345 Denver 37
3 34567 Chicago 2
4 67890 LA 10
5 90123 Chicago 31


Sheet 2
A B C D E F
1 Numbers Denver Chicago LA
2 12345 37 13 39
3 23456 30 45 40
4 34567 11 2 8
5 45678 3 6 22
6 56789 4 7 9
7 67890 1 5 10
8 78901 12 15 35
9 89012 17 18 23
10 90123 27 31 19
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top