Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching Multiple rows using VLOOKUP with wildcard(*,?) lookup va
Given data_array:
abc 1000 abx 2000 bcd 3000 def 4000 bhg 3200 and lookup_value is b??, how can we obtain result with bcd 3000 bhg 3200 using VLOOKUP thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wildcard lookup | Excel Worksheet Functions | |||
vlookup - multiple lookup values | Excel Worksheet Functions | |||
lookup with multiple rows returned | Excel Discussion (Misc queries) | |||
Searching rows with multiple columns criteria | Excel Worksheet Functions | |||
VLOOKUP - Multiple cells in lookup value | Excel Worksheet Functions |