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!

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!