DOUBLE VLOOKUP

[instereo911 via OfficeKB.com]

Good afternoon, I tried most of all that was posted on double VLOOKUP but had
no sucess.

My Chart Looks Like this:

Sheet 1,

A B C D
1 01/01/2007 AM 67 84
2 01/01/2007 CU 283 51
3 01/01/2007 EF 85 412
4 01/01/2007 EU 66 985
5 01/02/2007 AM 61 81
6 01/02/2007 CU 280 61
Etc - all the way up to 02/28/2007

I am looking for sheet2 to look like this and grab the data
A B c D E
F

1 01/01/2007 01/01/2007 01/02/2007 01/02/2007
2 AM 67 84 61
81
3 CU 283 51 280
61
4 EF 85 412 --
--
5 EU 66 985 --
--

So I want to say something like this on sheet 2 (because sheet 1 has all the
data stored) in cell C2 ... =vlookup(B2&C1,SHEET1!A16,3,FALSE)

And it is not working... Any ideas?

Thanks everyone

 

[Dave Peterson]

As long as those are numbers in C, you could add headers to your data (row
1???).

Then you could select your range A1xxx
data|pivottable
follow the wizard until you get to a step that has a "Layout" button on it.

Click that Layout button
Drag the header button for the date to the column Field
Drag the header button for the type(??) to the row field
Drag each header button for the quantities to the data field.
If you don't see "sum of", double click on that "button" and choose summarize by
sum.

One of the nice things about using a pivottable is that you can quickly
summarize that data in different looks.

Those grey buttons are live and can be dragged to other places.
You can swap date and type locations. You can drag the Data button in front of
the type button.

One tip. Once you see the look you like, save that file. Then experiment to
your heart's content.

It'll be easy to screw up, but just close without saving and reopen.

You may find a different summary you like better.