in the formula bar type =vlookup(
then click on the equals sign next to the formula bar, the function
wizard shows, see what happens when you follow the wizard,
by the way vlookup only works left to right, could that be the problem?


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=573429