Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Im trying to return a value in cell B2 by matching the values in C2 & D2. The values of C2 & D2 would use a lookup table on a different sheet, named Saturday form A3:AP27. C2 is 510n & D2 is 5:47. Im hoping to retrieve the value in column A of the lookup table when those two match in the same row. The lookup table will have 510n in many different cells throughout the table and 5:47 may be in the table more than once, but somewhere within the table the two will be side by side in the same row, (example K4 & L4) and retrieve the value in A4. Hope this explanation makes some sort of sense. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions |