=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))).

Im using this formula to take names from one sheet and display on
another sheet but when I put the formula in B2 Im not getting any
results. Can someone help me please?


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