Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DOUBLE VLOOKUP
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!A1:D6,3,FALSE) And it is not working... Any ideas? Thanks everyone -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200705/1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
DOUBLE VLOOKUP
As long as those are numbers in C:D, you could add headers to your data (row
1???). Then you could select your range A1:Dxxx 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. "instereo911 via OfficeKB.com" wrote: 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!A1:D6,3,FALSE) And it is not working... Any ideas? Thanks everyone -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200705/1 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double VLookup | Excel Discussion (Misc queries) | |||
Need Help with Double Vlookup | Excel Discussion (Misc queries) | |||
double vlookup in same function | Excel Worksheet Functions | |||
Vlookup - double criteria | Excel Worksheet Functions | |||
VLOOKUP - DOUBLE CRITERIA | Excel Worksheet Functions |