You get #N/A when using VLOOKUP is the sought value is not present in
the table - perhaps you might need to add some more codes, or check
that you don't have spaces etc at the end of them.

Hope this helps.

Pete

On Apr 17, 9:54 am, Joe wrote:
HI,for some reason it doesnt work for me today.
TABLE example:
Acc type
73010 ADMIN Travel cost
74000 ADMIN

the other is:
Trx Date Acc # Acc name
01/04/2006 73010-100-CAN-000 Customer DL - Canada#N/A
28/04/2006 74000-100-IRL-000 Customer DL - Ireland #N/A
30/04/2006 63615-100-IRL-000 Customer DL - Ireland #N/A
30/04/2006 63615-100-IRL-000 Customer DL - Ireland #N/A

Using the formula

=VLOOKUP(LEFT(B78,5),ADMIN!$A$1:$B$32,2,FALSE)

I get #N/A

Wot am i doing wrong?