+ Reply to Thread
Results 1 to 7 of 7

Nested if statements

  1. 03-24-2016, 05:49 PM #1
    pjzapped
    pjzapped is offline
    Registered User
    Join Date
    08-04-2014
    Location
    Harrogate
    MS-Off Ver
    2016
    Posts
    17

    Post Nested if statements

    Hello

    I am trying to copy values from a table if a cell on SelectHome1 equals one of 14 column names on InGroup2
    I need to copy 35 rows of the column from a table on InGroup! to another sheet based on the value of a cell on a SelectHome!.

    I have tried nested if statments

    =IF(SelectHome!$D$19=InGroup!$A$3,InGroup!A5,"")
    =IF(SelectHome!$D$19=InGroup!$B$3,InGroup!B5,"")
    =IF(SelectHome!$D$19=InGroup!$C$3,InGroup!C5,"")
    =IF(SelectHome!$D$19=InGroup!$D$3,InGroup!D5,"")
    =IF(SelectHome!$D$19=InGroup!$E$3,InGroup!E5,"")
    =IF(SelectHome!$D$19=InGroup!$F$3,InGroup!F5,"")
    =IF(SelectHome!$D$19=InGroup!$G$3,InGroup!G5,"")
    =IF(SelectHome!$D$19=InGroup!$H$3,InGroup!H5,"")
    =IF(SelectHome!$D$19=InGroup!$J$3,InGroup!J5,"")
    =IF(SelectHome!$D$19=InGroup!$J$3,InGroup!J5,"")
    =IF(SelectHome!$D$19=InGroup!$K$3,InGroup!K5,"")
    =IF(SelectHome!$D$19=InGroup!$L$3,InGroup!L5,"")
    =IF(SelectHome!$D$19=InGroup!$M$3,InGroup!M5,"")
    =IF(SelectHome!$D$19=InGroup!$N$3,InGroup!N5,"")

    Nested into =IF(SelectHome!$D$19=InGroup!$A$3,InGroup!A5,IF(SelectHome!$D$19=InGroup!$B$3,InGroup!B5,IF(SelectHome!$D$19=InGroup!$C$3,InGroup!C5,...etc and then copying this down on each row

    but I cannot nest sufficient statement to match the 14 choices

    Thanks for having a look
    Reply With QuoteRegister To Reply
  2. 03-24-2016, 05:55 PM #2
    Shareez Saleem
    Shareez Saleem is offline
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    696

    Re: Nested if statements

    Can you please upload a sample sheet?
    Reply With QuoteRegister To Reply
  3. 03-24-2016, 05:56 PM #3
    zico8
    zico8 is offline
    Forum Contributor
    Join Date
    07-13-2015
    Location
    Poland
    MS-Off Ver
    MS Office 365
    Posts
    174

    Re: Nested if statements

    try:

    Please Login or Register  to view this content.
    not tested ;/
    Reply With QuoteRegister To Reply
  4. 03-24-2016, 06:12 PM #4
    eibi
    eibi is offline
    Registered User
    Join Date
    01-08-2014
    Location
    Missouri
    MS-Off Ver
    365
    Posts
    87

    Re: Nested if statements

    Try this -- see if does what you are wanting:

    =INDEX(InGroup!$A$5:$N$5,,MATCH(SelectHome!D19,InGroup!$A$3:$N$3,0))

    I've set up a sample file (attached). You pick the value from InGroup A3:N3 in the yellow box; it gives you the corresponding output from InGroup A5:N5 in the orange box.
    Attached Files Attached Files
    Last edited by eibi; 03-24-2016 at 06:18 PM.
    Reply With QuoteRegister To Reply
  5. 03-24-2016, 06:22 PM #5
    pjzapped
    pjzapped is offline
    Registered User
    Join Date
    08-04-2014
    Location
    Harrogate
    MS-Off Ver
    2016
    Posts
    17

    Re: Nested if statements

    Thanks Guys

    eiibi your solution is working great thanks so much

    Pjzapped
    Reply With QuoteRegister To Reply
  6. 03-24-2016, 06:58 PM #6
    zico8
    zico8 is offline
    Forum Contributor
    Join Date
    07-13-2015
    Location
    Poland
    MS-Off Ver
    MS Office 365
    Posts
    174

    Re: Nested if statements

    my modified formula:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 03-24-2016, 07:02 PM #7
    pjzapped
    pjzapped is offline
    Registered User
    Join Date
    08-04-2014
    Location
    Harrogate
    MS-Off Ver
    2016
    Posts
    17

    Re: Nested if statements

    Thanks Zico8 your solution is also, many thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Nested if statements containing multiple and statements
    By John M. in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-22-2014, 11:48 PM
  2. questions with if statements and nested if statements
    By Pat Excel in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-03-2013, 01:41 PM
  3. Nested if statements with AND and OR statements
    By joeljoel in forum Excel General
    Replies: 4
    Last Post: 08-08-2011, 12:57 PM
  4. Multiple nested IF statements and AND statements
    By TonyGetz in forum Excel General
    Replies: 2
    Last Post: 12-14-2010, 03:07 AM
  5. Nested 'IF' statements
    By MustangLvr in forum Excel General
    Replies: 10
    Last Post: 11-03-2009, 12:20 PM
  6. Nested If statements / logic statements
    By Brainless_09 in forum Excel General
    Replies: 3
    Last Post: 06-17-2009, 02:59 PM
  7. Nested IF statements or CHOOSE statements needed for multiple conditions formula
    By salmansaif in forum Excel General
    Replies: 12
    Last Post: 05-15-2009, 08:38 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1