Your Vlookup formula can only read from ONE lookup value (reference
cell) at a time... hence your formula in B2:

=IF(ISERROR((vlookup($A$2:$A$31,Sheet2!$A$2:$A$14, 1,0)), "Not
Active",vlookup($A$2:$A$31,Sheet2!$A$2:$A$14,1,0)) ).

should be:

=IF(ISERROR((vlookup($A2,Sheet2!$A$2:$A$14,1,0))," Not
Active",((vlookup($A2,Sheet2!$A$2:$A$14,1,0))).

then copy this down the range B3:B31. Each cell in 'B' will return
either the matching value from Sheet2 or the "Not Active" text.

Note the change in the vlookup reference from $A$2:$A$31 to $A2. As
you copy this down, the range will change in B3 to $A3, in B4 to $A4,
etc.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=384538