Lookup related question

[Craig]

Hi

I have a 2 column table I want to use as a lookup table; one column showing
all the company's employee names (last then first in one cell but no middle
initials) and the other column their department code.

I just imported another separate smaller table with employee names, salary,
date of hire, but no department code. However the employee names in this
table which will be the lookup value, have some middle initials at the end as
opposed to the employee names in the lookup table which do not have middle
initials.

I want to lookup the department code based on the name in the imported
table...but using False match gives me some "N/A" results on some since some
of the imported names have middle initials while the master lookup table has
no middle initials..when I tried a "true" match I keep getting the wrong
department code

any ideas???? thanks!

 

[Michael Arch]

You could use the text to column functionality using space as the delimiter,
this will create a separate column for the Midle name then delete the column
and reconcatenate.
Another method is to use the Mid Function combined with the Find function,
embeded in your lookup function, but it will be easier to explain if you post
an example with the table and some cell references.