That didnt help!!
Thanks anyway. Does it have to do anything with the fact that I am
using Excel 97.

Morrigan Wrote:
Maybe try put a $ sign in front of the first A2

ie.
=VLOOKUP($A2,Detail!$A$2:$F$29497,5,FALSE)


--
navneetjn
------------------------------------------------------------------------
navneetjn's Profile: http://www.excelforum.com/member.php...o&userid=25330
View this thread: http://www.excelforum.com/showthread...hreadid=388108