What I am basically trying to do is sum together the results from 2 vlookups and an if function.
So the various formulas:
=VLOOKUP(T4,statleader,7,0)
=VLOOKUP(T4,TEML,3,FALSE) and
=IF(AO49="T",2,IF(AO49="E",4,IF(AO49="M",6,IF(AO49="L",8,0))))
Is there an elegant way in a single formula to sum the results of these 3 formulas?
Thank you for taking a shot at this!
Bookmarks