I've not used VLookup before. I'm a novice at best with Excel. I've tried simplifying my IF formulas by the end value. I thought that would be easier than trying to have 50-60 IF statements! I've used the following formula but get a return of #VALUE. I have end values of "D," "B," and "E." I've not gotten to E in the formula yet because it didn't work after I added the "D" scenarios.
Here is the nested IF i'm trying to work with...
=IF(OR(AH102="B",AH103="B",AH104="B",AH105="B",AH106="B",AH107="B",AH108="B",AH109="B"),"B",""),IF(OR(AH112="D",AH113="D",AH114="D",AH115="D",AH116="D",AH117="D",AH118="D",AH119="D",AH120="D",AH121="D",AH122="D",AH123="D",AH124="D",AH125="D",AH126="D"),"D","")
Is VLookup better when choosing between these end values. Is there a great source to help me understand that approach better? I could attach a spreadsheet sample if needed. Any help is greatly appreciated!
Thanks!
Bookmarks