software

I have a list of various food in Sheet!1 A, and the calories are listed in
colomn B in Sheet!1.
I want to have the calories transfered to Sheet!2, so that if i write banana
in Sheet!2 A1, the number of calories from Sheet!1 B3(wich is written next to
quot;bananaquot; in A3), will appear. And if I then write blueberries instead, I
would like the calorieno. for blueberries, wich again comes from Sheet!1
column B
Is that possible - and if, then how.
Therese

Make sure in Sheet1, you type names in A1 (food) and B1(calories)
In Sheet2, B3, insert this formula:
VLOOKUP(A3,'Sheet1'!$A$1:$B$30,2,FALSE))
--
Anne Murrayquot;Theresequot; wrote:

gt; I have a list of various food in Sheet!1 A, and the calories are listed in
gt; colomn B in Sheet!1.
gt; I want to have the calories transfered to Sheet!2, so that if i write banana
gt; in Sheet!2 A1, the number of calories from Sheet!1 B3(wich is written next to
gt; quot;bananaquot; in A3), will appear. And if I then write blueberries instead, I
gt; would like the calorieno. for blueberries, wich again comes from Sheet!1
gt; column B
gt; Is that possible - and if, then how.
gt; Therese

Hi Anne
It worked, just amazing! Thanks a lot :-)
--
Theresequot;FinRazelquot; skrev:

gt; Make sure in Sheet1, you type names in A1 (food) and B1(calories)
gt; In Sheet2, B3, insert this formula:
gt; VLOOKUP(A3,'Sheet1'!$A$1:$B$30,2,FALSE))
gt; --
gt; Anne Murray
gt;
gt;
gt; quot;Theresequot; wrote:
gt;
gt; gt; I have a list of various food in Sheet!1 A, and the calories are listed in
gt; gt; colomn B in Sheet!1.
gt; gt; I want to have the calories transfered to Sheet!2, so that if i write banana
gt; gt; in Sheet!2 A1, the number of calories from Sheet!1 B3(wich is written next to
gt; gt; quot;bananaquot; in A3), will appear. And if I then write blueberries instead, I
gt; gt; would like the calorieno. for blueberries, wich again comes from Sheet!1
gt; gt; column B
gt; gt; Is that possible - and if, then how.
gt; gt; Therese