Hi,
I have 3 different calulations and i need to merge to get the highest value of them into a cell
These are the vlookup formulas i am using. Currently i am using MAX function to obtain the max value, but i need a single formula for this.
=SUM(D7*(VLOOKUP(D10,HSS:Sheet2!I2:I7,8,FALSE)))
=SUM(D8*(VLOOKUP(D10,HSS:Sheet2!J2:J7,9,FALSE)))
=SUM(F8*(VLOOKUP(D10,HSS:Sheet2!K2:K7,10,FALSE)))
Please let me know how to bring them into a single formula
I have 3 different calulations and i need to merge to get the highest value of them into a cell
These are the vlookup formulas i am using. Currently i am using MAX function to obtain the max value, but i need a single formula for this.
=SUM(D7*(VLOOKUP(D10,HSS:Sheet2!I2:I7,8,FALSE)))
=SUM(D8*(VLOOKUP(D10,HSS:Sheet2!J2:J7,9,FALSE)))
=SUM(F8*(VLOOKUP(D10,HSS:Sheet2!K2:K7,10,FALSE)))
Please let me know how to bring them into a single formula