Hi

I've post an example of two ways to skin this cat

Also a useful link on Vlookup's
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm


http://cjoint.com/?hwkSkkmizO

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=563950