Excel -Match on a field and fill in?

[aj3221]

I have a spreadsheet that has 2 tabs. The one tab lists items sold (qty & $) in 2008. The 2nd tab lists items sold in 2009 (qty & $). I created a column in the 2008 spreadsheet that has a spot for 2009 qty sold & $'s: Column A = Item #, Column B = Item Desc, Column C = 2008 Qty sold, Column D = 2008 $'s sold, Column E = 2009 Qty Sold, and Column F = 2009 $'s sold. Is there something I can set up so it will match on the Item # field and fill in the 2009 fields? I can also throw this all into 1 tab too and do something there? Right now I have 2008 and 2009 (as a test) all in 1 spreadsheet. 2009 I have highlighted in yellow so i know its 2009. Then I sorted by item# and I'm dragging the 2009 totals into the 2009 column, the deleting the item#, item desc from that line...etc.

 

[kjv1611]

1. Some sample data would surely be helpful.
2. For at least part of your issue, you might could use MS Query if standard formulas don't cut it for you.

Otherwise, you could also move the whole thing to Access, and just spit out what reports you need in Excel.

--

"If to err is human, then I must be some kind of human!" -Me

 

[Gavona]

In a single sheet add a column for Year then a pivot table will give you a report giving the the info you need - just a few minutes work. My preferred solution.

Or before combining the sheets move the 2008n data to a new column. Then use a pivot table or Query to summarise with 1 row per Item #.

OR in 2 sheets use vloookup in 2008 to fill in the data for the other year. Issue with this is picking up data for items which only appear in 2009

Gavin