Need help with a nested IF with an ISNA (I think)

**nighthalcyon** · 07-25-2013, 04:36 PM

Hi all, I've attached a sample workbook. I am trying to create one main "master" column of numbers from 7 columns with data in it. Essentially, column 1 has priorty, so if there is something in there, I want to use that. But if there is an #N/A in there, I want to use what is in column 2. If there are #N/A's in columns 1 and 2, then I want to use what is in column 3....and so on.

I was thinking a combination of IF and ISNA would work, and I can get it to work for 2 columns, but I'm having trouble getting it to work for all 6.

Sample file attached. Thanks a lot for your help.

**tigeravatar** · 07-25-2013, 04:46 PM

nighthalcyon,

In cell H2 and copied down:

Please Login or Register  to view this content.

Or if you don't mind seeing the #N/A error message if there is no number to return, you can leave off the first part:

Please Login or Register  to view this content.

**AZ-XL** · 07-25-2013, 04:51 PM

Hi
Paste the formula below to h2 cell and drag it down
=INDEX(A2:G2,MATCH(TRUE,IF(NOT(ISERROR(A2:G2)),TRUE),0))

After entering formula press Ctrl+Shift+Enter, nbot only enter.
Good luck

**nighthalcyon** · 07-25-2013, 04:55 PM

Originally Posted by tigeravatar

nighthalcyon,

In cell H2 and copied down:

Please Login or Register  to view this content.

Or if you don't mind seeing the #N/A error message if there is no number to return, you can leave off the first part:

Please Login or Register  to view this content.

Worked perfectly. Thanks very much for your help !!!

Edit: Looks like I've already repped you for some of your help earlier. But I'll get you again when I can.

**tigeravatar** · 07-25-2013, 05:13 PM

You're very welcome

And I don't really worry about rep too much, your acknowledgement and thanks is more than enough.

Need help with a nested IF with an ISNA (I think)

LinkBack

Thread Tools

Rate This Thread

Display

Need help with a nested IF with an ISNA (I think)

Re: Need help with a nested IF with an ISNA (I think)

Re: Need help with a nested IF with an ISNA (I think)

Re: Need help with a nested IF with an ISNA (I think)

Re: Need help with a nested IF with an ISNA (I think)

Thread Information

Users Browsing this Thread

Similar Threads

Adding ISNA to long nested IF statements with vlookups

Streamlining nested IF/ ISNA

Nested If's/VLOOKUP/ISNA

Excel 2007 : Nested IF, AND IF, ISNA IF.. Arghhh

nested if statment - needs if(isna

Bookmarks

Bookmarks

Posting Permissions