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"," "))) |