Forum Discussion
making a formula for a drop down list
Hello everyone I am trying to make a calculator giving nutrition information from different baby milk formulas. The information for this is in a table in a separate excel sheet, Sheet 2 The milk for...
Hi,
I named the range in Sheet 2 "Data"
I added a sample record in Row # 3 using your drop list
I created the function in cell D 3 as follows:
=VLOOKUP($C3,Data,COLUMNS($J$1:K1),0)/100*($B3/$A3)
Copy the function to the left and down
Test using different items from the drop list
You may consider wrapping it in an IFERROR function
=IFERROR(VLOOKUP($C3,Data,COLUMNS($J$1:K1),0)/100*($B3/$A3),"")
Hope that helps
File attached