I want to lookup a text field, but although the field I am looking up against
contains the text in my lookup field, it is not exact so Vlookup is not
returning the value, i.e. the field I am using to identify against contains
first initial and surname and the sheet I am looking up contains full name.
I have tried the True option, but it doesn't work properly for all of the
entries. Is there another formula to use.