Forum Discussion
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 t...
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.