Thread: vlookup help!!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Blue
 
Posts: n/a
Default 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.