hudini,

When you use VLOOKUP the dat you are reference must brgin in column 1.
i.e. the item you are typing in must br located in the first column of
the array you are searching. you can then designate which column to
search. Post your format and I will try and help you.


--
dainbrammage
------------------------------------------------------------------------
dainbrammage's Profile: http://www.excelforum.com/member.php...o&userid=35159
View this thread: http://www.excelforum.com/showthread...hreadid=549244