wildcard in formula vlookup

M

Michael

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!
 
J

JMB

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))
 
Top