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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup help!!
you mean you ant total sales?
vllookup(a,janshhetrange,2,0)+vlookup(a,febsheetra nge,2,0)........ or a display of each month say in the cell called jan vlookup(a,janshhet range,2,0) next to feb=vlookup(a,febsheetrange,2,0) obviuosly the a could be a reference to a cell where you could type or select a b c etc... -- paul remove nospam for email addy! "Blue" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup help!!
thanks.
I need total sales for A for each month separately and I want to be able to do this easily for B and C as well So how do i copy the formular to populate the whole spreadsheet aul" wrote: you mean you ant total sales? vllookup(a,janshhetrange,2,0)+vlookup(a,febsheetra nge,2,0)........ or a display of each month say in the cell called jan vlookup(a,janshhet range,2,0) next to feb=vlookup(a,febsheetrange,2,0) obviuosly the a could be a reference to a cell where you could type or select a b c etc... -- paul remove nospam for email addy! "Blue" wrote: 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. |
Reply |
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 |