| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to transfer a sum from one spredsheet to another
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to transfer a sum from one spredsheet to another
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to transfer a sum from one spredsheet to another
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transfer data from multiple worksheets | Excel Discussion (Misc queries) | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
| Help - now really stuck! File transfer problem | Excel Discussion (Misc queries) | |||
| How do you transfer data from an input form in excel to an excel l | Excel Discussion (Misc queries) | |||
| HOW TO TRANSFER AUTOCORRECT DICTIONARY TO NEW COMPUTER?? | Setting up and Configuration of Excel | |||
Linear Mode
