thank you Paul Lautman

worked perfectly





Paul Lautman Wrote:
Paul Lautman wrote:
Pivotrend wrote:
didnt work

Try A2: =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,FALSE)
instead

Actually make that

A2: =VLOOKUP(A1,Sheet2!$A$1:$B$6,2,FALSE)


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=521534