Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup with 2 criteria
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup with 2 criteria
See this example:
http://www.freefilehosting.net/download/3f3jf Regards, Ryan--- -- RyGuy "mwear" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup with 2 criteria
It's a blocked site. Thanks anyway. I'll try and look at home.
"ryguy7272" wrote: See this example: http://www.freefilehosting.net/download/3f3jf Regards, Ryan--- -- RyGuy "mwear" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
LOOKUP with 2 or more criteria | Excel Worksheet Functions | |||
Lookup on two criteria | Excel Worksheet Functions | |||
Lookup? for more than one criteria | Excel Worksheet Functions | |||
Lookup: 2 criteria | Excel Discussion (Misc queries) |