How to transfer a sum from one spredsheet to another

[Therese]

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
"banana" 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

[FinRazel]

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 Murray


"Therese" wrote:

> 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
> "banana" 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

[Therese]

Hi Anne
It worked, just amazing! Thanks a lot :-)
--
Therese


"FinRazel" skrev:

> 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 Murray
>
>
> "Therese" wrote:
>
> > 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
> > "banana" 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