And you have another response at your other thread in .programming.

numerion wrote:

=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

--

Dave Peterson