Thread: How do I throw in an ISERROR function on a complicated VVLOOKUP?
View Single Post
  #1   Report Post  
KenRamoska
 
Posts: n/a
Default 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"," ")))
Reply With QuoteReply With Quote