Two things to watch out for:
1) is the table sorted or not, if sorted use True; otherwise, False
2) the table itself should be a named table or be addressed with
absolute references.

Vlookup Workdsheet Function
http://www.mvps.org/dmcritchie/excel/vlookup.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Zygan" wrote in message
...

why is it that when you look up a value using vlookup the value always
has got to be in the first row ? or can i fix this ?


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=548238