I have sales by month for apples, oranges, and banannas, and in cell A2 I want to make it so I can pull in from another sheet and do a sum(Jan,feb,mar) but I want to make it so that if the word in cell A1 is banannas it will pull the numbers for banannas from the other sheet and put it in A2, if A1 is apples it will put in the numbers for apples in A2. The other sheet is set up in cells like this:
Fruit: Jan Feb Mar Apr etc....
Apples 2 4 2 1
oranges 6 5 3 3
banannas 5 3 2 1
I am thinking I can do an Hlookup, but am not sure, I am changing months to quarters and so it will simply add the 3 months. I want it so the formula is all in cell A2. Can anyone help?
Bookmarks