ExcelBanter - vlookup help!!

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - vlookup help!! (https://www.excelbanter.com/excel-worksheet-functions/94101-vlookup-help.html)

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.

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.