Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup help!!
here is my problem.
I have 12 spreadsheets with information on monthly sales to different customers A, B , C. For example January spreadsheet will have, say 10 sales to A, 15 sales to B, 8 sales to C etc. And February spreadsheet will have say 12 sales to A, 5 sales to B, 11 sales to C I want to create an automated spreadsheet that selects sales to Customer A from January spreadsheet, February Spreadsheet, March Spread Sheet....December Spreadsheet. Is there a way to use V lookup to do this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |