Sorry i was away from my desk. Thanks for the help

My formula is =VLOOKUP(A6,TEST!A3:F3,6,FALSE)

I drag this down accross 50 values


--
trafficbroker
------------------------------------------------------------------------
trafficbroker's Profile: http://www.excelforum.com/member.php...o&userid=28710
View this thread: http://www.excelforum.com/showthread...hreadid=525232