wildcard in formula vlookup

[Guest]

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,2,false)

Please help!

Thanks!

 

[Guest]

Try:
=INDEX('Field Service'!D, MATCH("*Accrual*", 'Field Service'!C:C, 0))

Or, if I understand what you're truly looking for correctly:
=INDEX('Field Service'!D, MATCH("*"&RIGHT(A33,LEN(A33)-FIND(":",A33))&"*",
'Field Service'!C:C, 0))