Anthony

Hi Karen, thanks for your query. There's quite a lot on the net about this problem so you're not alone. Have a look here:

http://help.lockergnome.com/office/Vlookup-returning-NA-referencing-cell-data-sheet--ftopict1006537.html

...and here:

http://www.accountingweb.co.uk/anyanswers/vlookup-na-returned

Try here for some workarounds:

http://www.free-training-tutorial.com/shortsum/vlookup-isnaShortsum.html

and here:

http://www.ozgrid.com/Excel/stop-na-vlookup.htm

See if any of that works on our data and let me know how you get on.

All the best,

Anthony