| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup in multiple columns
I have a lookup problem. I have to lookup for matching data in cells A2 to
E50, match it against a static value "BOOST" and if i hit a match, return the corresponding value in column "F". Multiple cells in A2 to E50 range may have the value "BOOST". It is K if I catch the first match an give corresponding value. I tried Offset-Match combination with array.. but this is not returning favourable results. Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup across multiple columns within multiple sheets | Excel Discussion (Misc queries) | |||
| Lookup across multiple columns | Excel Discussion (Misc queries) | |||
| Lookup multiple columns | Excel Worksheet Functions | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| Lookup + Sum multiple columns | Excel Worksheet Functions | |||
Threaded Mode
