Thanks for the help.

One thing that I think I have just figured out about the VLookup
command is that it has to start from the first column (A) of your
spreadsheet otherwise the Lookup doesn't work.

When I moved the data across the spreadsheet to start at column C, and
changed the return column value accordingly (to column 4 instead of 2),
I found that I returned an error. Am I doing something wrong or is this
the only way the Lookup works?

regards, Nik


--
Ntisch
------------------------------------------------------------------------
Ntisch's Profile: http://www.excelforum.com/member.php...fo&userid=5791
View this thread: http://www.excelforum.com/showthread...hreadid=382370