Vlookup

Hi Ben

Thankyou for your question

I have come up with a formula that returns a lookup result if a cell contains a particular string, e.g the lookup table contains the value Peter and you want it to work for both Peter and Pete

=IF(ISERROR(FIND("Pet",A2)),"",VLOOKUP(A2,$J$2:$K$6,2,FALSE))

The find function looks for a combination of letters within a string, here "pet" within a cell containing the word peter. If the cell doesn't contain the string then the function returns an error. Thus we nest this within an iserror function, itself within an if function. If the if result is false, i.e there is no error then it runs the vlokup, otherwsie it returns an empty string

Note Find is case sensitive

Hope this helps

Regards

Stephen