Problem with formula

[numerion]

=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?

 

[swatsp0p]

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

 

[numerion]

For some reason Im having problems with the "Not Active" statement in
the formula Im getting #value! in red as an error?

 

[Bob Phillips]

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

 

[swatsp0p]

I think there is a syntax error in the original formula, copy and past
this into B2:

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


Does this work for you

 

[Dave Peterson]

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