Different Vlookup formula into one formula

[BEEALTAIR]

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

 

[Joe4]

Welcome to the Board!

Note that the SUM function serves no purpose in your formula. You use that when adding up multiple values in a single formula.

How about:

=MAX(D7*VLOOKUP(D10,HSS:Sheet2!I2:I7,8,FALSE),D8*VLOOKUP(D10,HSS:Sheet2!J2:J7,9,FALSE),F8*VLOOKUP(D10,HSS:Sheet2!K2:K7,10,FALSE))

 

[BEEALTAIR]

Welcome to the Board!

Note that the SUM function serves no purpose in your formula. You use that when adding up multiple values in a single formula.

How about:

=MAX(D7*VLOOKUP(D10,HSS:Sheet2!I2:I7,8,FALSE),D8*VLOOKUP(D10,HSS:Sheet2!J2:J7,9,FALSE),F8*VLOOKUP(D10,HSS:Sheet2!K2:K7,10,FALSE))

Hi, Thank you so much, this worked. May i please know if i can make a formula deciding on the value of above code in another cell. So if the Max is this calculation then i need it to calculate something else. Please help

 

[Joe4]

Hi, Thank you so much, this worked. May i please know if i can make a formula deciding on the value of above code in another cell. So if the Max is this calculation then i need it to calculate something else. Please help

You should just be able drop that whole formula into your other calculation. There is no problem with imbedding calculations inside of other calculations in Excel.