Thread: Problem with formula

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

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"numerion" <numerion.1rpcav_1120576048.5616@excelforum-nospam.com> wrote in
message news:numerion.1rpcav_1120576048.5616@excelforum-nospam.com...
>
> For some reason Im having problems with the "Not Active" statement in
> the formula Im getting #value! in red as an error?
>
>
> --
> numerion
> ------------------------------------------------------------------------
> numerion's Profile:
http://www.excelforum.com/member.php...o&userid=22975
> View this thread: http://www.excelforum.com/showthread...hreadid=384538
>

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

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"numerion" <numerion.1rpcav_1120576048.5616@excelforum-nospam.com> wrote in
message news:numerion.1rpcav_1120576048.5616@excelforum-nospam.com...
>
> For some reason Im having problems with the "Not Active" statement in
> the formula Im getting #value! in red as an error?
>
>
> --
> numerion
> ------------------------------------------------------------------------
> numerion's Profile:
http://www.excelforum.com/member.php...o&userid=22975
> View this thread: http://www.excelforum.com/showthread...hreadid=384538
>

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

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"numerion" <numerion.1rpcav_1120576048.5616@excelforum-nospam.com> wrote in
message news:numerion.1rpcav_1120576048.5616@excelforum-nospam.com...
>
> For some reason Im having problems with the "Not Active" statement in
> the formula Im getting #value! in red as an error?
>
>
> --
> numerion
> ------------------------------------------------------------------------
> numerion's Profile:
http://www.excelforum.com/member.php...o&userid=22975
> View this thread: http://www.excelforum.com/showthread...hreadid=384538
>

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

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"numerion" <numerion.1rpcav_1120576048.5616@excelforum-nospam.com> wrote in
message news:numerion.1rpcav_1120576048.5616@excelforum-nospam.com...
>
> For some reason Im having problems with the "Not Active" statement in
> the formula Im getting #value! in red as an error?
>
>
> --
> numerion
> ------------------------------------------------------------------------
> numerion's Profile:
http://www.excelforum.com/member.php...o&userid=22975
> View this thread: http://www.excelforum.com/showthread...hreadid=384538
>

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

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"numerion" <numerion.1rpcav_1120576048.5616@excelforum-nospam.com> wrote in
message news:numerion.1rpcav_1120576048.5616@excelforum-nospam.com...
>
> For some reason Im having problems with the "Not Active" statement in
> the formula Im getting #value! in red as an error?
>
>
> --
> numerion
> ------------------------------------------------------------------------
> numerion's Profile:
http://www.excelforum.com/member.php...o&userid=22975
> View this thread: http://www.excelforum.com/showthread...hreadid=384538
>

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

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"numerion" <numerion.1rpcav_1120576048.5616@excelforum-nospam.com> wrote in
message news:numerion.1rpcav_1120576048.5616@excelforum-nospam.com...
>
> For some reason Im having problems with the "Not Active" statement in
> the formula Im getting #value! in red as an error?
>
>
> --
> numerion
> ------------------------------------------------------------------------
> numerion's Profile:
http://www.excelforum.com/member.php...o&userid=22975
> View this thread: http://www.excelforum.com/showthread...hreadid=384538
>

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