Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I throw in an ISERROR function on a complicated VVLOOKUP?
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"," "))) |
#2
|
|||
|
|||
How about
=if(a6="", "",formula or a6=0 -- Don Guillett SalesAid Software "KenRamoska" wrote in message ... 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"," "))) |
#3
|
|||
|
|||
Try this: =IF(A6="","",IF(VLOOKUP(A6,CSM,8)="X","X",IF(VLOOK UP(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 -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=380513 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|