Hi,

Trying to use the VLOOKUP function on a column that has multiple names
(comma seprated) or with % in brackets. Data originally from MSProject. I
need to lookup from the left side only, match it with a standard value and
return the standard value.

Data to be matched - Bob Smith,Client or Bob Smith [88%]
Lookup says - Bob Smith

Can someone please help me with the equation?

I've tried to keep the equation simple, also tried left, trim etc. with no
luck. Not convinced INDEX will do the whole trick so tried it in combination
with vlookup - no luck.

This is the original equation, it works fine where the value in AA18 is
exactly the same as Resources!$B.

=VLOOKUP($AA18,Resources!$B:$C,1,FALSE)

Any help appreciated