| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
wildcard in formula vlookup
I want to use the formula
"RIGHT(A33,LEN(A33)-FIND(":",A33))" in a vlookup to find a text string and utilize a wildcard function to retrieve the field. Example vlookup("*Accrual*",'Field Service'!C:D,2,false) Please help! Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
wildcard in formula vlookup
Try:
=INDEX('Field Service'!D:D, MATCH("*Accrual*", 'Field Service'!C:C, 0)) Or, if I understand what you're truly looking for correctly: =INDEX('Field Service'!D:D, MATCH("*"&RIGHT(A33,LEN(A33)-FIND(":",A33))&"*", 'Field Service'!C:C, 0)) "Michael" wrote: I want to use the formula "RIGHT(A33,LEN(A33)-FIND(":",A33))" in a vlookup to find a text string and utilize a wildcard function to retrieve the field. Example vlookup("*Accrual*",'Field Service'!C:D,2,false) Please help! Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| VLOOKUP result is not showing up - only the formula | Excel Worksheet Functions | |||
| Question regarding wildcard in multi-criteria IF formula | Excel Worksheet Functions | |||
| IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Linear Mode
