C
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!
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!