Forum Discussion

Dave Galy's avatar
Dave Galy
Copper Contributor
Oct 04, 2018

Long IF Statement

I have a spreadsheet with about 150 conditions for an IF Statement, is there a better way to write my formula so I don't have extremely long IF Statement? Maybe a VLOOKUP?

 

This is what I've put together so far: 

=IF(J:J="0011",AH3,IF(J:J="0012",AH4, IF(J:J="0013",AH5,IF(J:J="0014"))))

 

Thanks,

BI & Data Analysis
excel
Formulas and Functions

1 Reply

  • Philip West's avatar
    Philip West
    Steel Contributor
    Oct 04, 2018

    Hi Dave,

    I would think that you best bet is indeed to use a vlookup or index/match, which ever you are most comfortable with.

     

    If you want to upload something with how your data is laid out, I or someone can look at it and show you how.