Menu

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

Search this Thread

Prev

Previous Post

Next Post

Next

#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 Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 05:28 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement