which lookup or reference function

M

Murph

I am trying to create a spreadsheet dealing with daily nutrition. I
want to be able to enter a food in the first column and the number of
servings in the second column, then have the rest of the row fill
automatically with appropriate values for calories, sodium, fat, etc.
Which "lookup" function will do this?

Thanks
 
D

Domenic

Assuming that Sheet2 contains your table, let's say A1:E100, enter the
following formula in Sheet1!C1, copy across and down:

=INDEX(Sheet2!C$1:C$100,MATCH(1,(Sheet2!$A$1:$A$100=Sheet1!$A1)*(Sheet2!$
B$1:$B$100=Sheet1!$B1),0))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER, and where
Sheet1!$A1 contains the food of interest, and Sheet1!$B1 contains the
number of servings. Adjust the range accordingly.

Hope this helps!
 
D

Domenic

Forgot to mention...

I assumed Column A of your table on Sheet2 contains the 'food', and
Column B contains the 'number of servings'.

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top