Forum Discussion

Luke_williams's avatar
Luke_williams
Copper Contributor
Apr 16, 2019

Multiple IF statements

I am looking at finding a formula for: =IF(B25=Sheet1!A2 than B26=Sheet1!B2 and B27=Sheet1!C2 .... and so on BUT =IF(B25=Sheet1!A3 than B26=Sheet1!B3 and B27=Sheet1!C3
excel
Twifoo's avatar
Twifoo
Silver Contributor
Apr 16, 2019

It seems that you need a formula like this in B26, copied down rows:
=INDEX(CHOOSE(1+(B$25=Sheet1!A$3),
Sheet1!B$2:J$2,Sheet1!B$3:J$3),
ROW()-25)

Luke_williams's avatar
Luke_williams
Copper Contributor
May 08, 2019

Twifoo 

I have tried your formula and it works for the first drop down, but when I drop down to the second name which is on Sheet1!A$2 it doesnt pick up the line he is on. Am I missing something?

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    May 09, 2019
    Please attach your sample file so I can see what's causing the error.
    • Twifoo's avatar
      Twifoo
      Silver Contributor
      May 09, 2019
      What's the address of the formula you're referring to?
      • Luke_williams's avatar
        Luke_williams
        Copper Contributor
        May 09, 2019

        Twifoo the drop down in Sheet2 B25, so when you choose PR it pre fills Sheet2 B26:B29 from the info in Sheet1 B2:F2

        And Im hoping that you can get it to do the same thing when you choose MB from the Sheet2 B25 drop down to pick up the info in Sheet1 B3:F3 to show in the Sheet2 B26:B29 fields

         

Resources