How do I throw in an ISERROR function on a complicated VVLOOKUP?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a working VLOOKUP below. Of course the desitination cell says #N/A
until I put something in A6. I tried ISERROR but it says too many arguments.
Did I do this wrong? Can anyone help? Thanks.


=IF(VLOOKUP(A6,CSM,8)="X","X",IF(VLOOKUP(A6,NPM,8)="X","X",IF(VLOOKUP(A6,PM,8)="X","X"," ")))
 
How about
=if(a6="", "",formula
or
a6=0


--
Don Guillett
SalesAid Software
(e-mail address removed)
KenRamoska said:
Hi, I have a working VLOOKUP below. Of course the desitination cell says #N/A
until I put something in A6. I tried ISERROR but it says too many arguments.
Did I do this wrong? Can anyone help? Thanks.
Click to expand...
=IF(VLOOKUP(A6,CSM,8)="X","X",IF(VLOOKUP(A6,NPM,8)="X","X",IF(VLOOKUP(A6,PM,
8)="X","X"," ")))
 
Try this:

=IF(A6="","",IF(VLOOKUP(A6,CSM,8)="X","X",IF(VLOOKUP(A6,NPM,8)="X","X",IF(VLOOKUP(A6,PM,8)="X","X","
"))))

when A6 is blank, your target cell will return a blank, when A6 is not
blank, the remainder of your formula is processed.

Note: I notice you have the formula return a space (" ") if none of
the ranges contain "X". If you want simply to return a blank cell, use
"" (without the space between the quote marks).

HTH

Bruce
 
Back
Top