Lookup with 2 criteria

[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

 

[ryguy7272]

See this example:
http://www.freefilehosting.net/download/3f3jf

Regards,
Ryan---

 

[mwear]

It's a blocked site. Thanks anyway. I'll try and look at home.