T Wrote:
Ya i'm aware that vlookups does that. I need to know how to do it using
vlookup
[/color]
Search the newsgroups for VLOOKUP you will get tons of info
use excels "help" and search for vlookup
--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread:
http://www.excelforum.com/showthread...hreadid=541693