Vlookup or Access?

Hello,

I wanted to ask a general question about what people think about whether it would be more useful to use vlookups or Access when combining multiple spreadsheets into one, ease of reproducing the report should be considered. Right now I have two, potentially three spreadsheets that I need to merge, I'm currently using vlookups to pull four or five columns from one to the other. The software company that we use is working on building the reports that we need so we don't have to do this forever but until that happens I'm looking for the easiest way to reproduce my final report.

Thanks.

Thanks,

I'm going to give PowerPivots a try, I've done something similar in the past with a macro, I guess I'm just not in a macro kinda mood right now.

Regarding the powerpivot and calculated fields, Row headings are ID #'s which is what I've used to create relationships with,
value columns include Sum of Total Sales and Sum of Commission. Can I create a calculated field to give me Commission/Sales?
Everything I've read seems to point to NO. Something to do with not being able to create calc fields using summary fields...

Thanks.

I guess I need to read through those links a little more carefully, Thanks mikeTRON.

Another question for powerpivot, I have more than one text field, not really a problem because I can use them as my row labels and then put the ID# in as a value with Sum. I also have two columns that have dates, I had previously created a standalone pivot and was able to get the dates in as values with Product and then just format the column as Short Date, worked fine, when using the powerpivot I don't seem to have that option.

Yes, thanks. A few other things have come up but I think I'm getting the hang of it now.

Thanks, I love the sense of satisfaction that you get when you figure out/find how to get something to work and then it does.