In the annual table tab, I want to be able to select a sales person or other field, and create a table that will pull data from all the tabs. For example, if I select the salesperson Kelly, I want it to pull all of the data from January, February, and March, and compile it into a table. I would want the table to be dynamic also - I want to be able to quickly sum/average all of that salesperson's sales for all months. Thank you in advance.
Hi and welcome to the forum,
Please see attached workbook.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Impressive.
I do have one question:
1. What function does the column formula perform within the vlookup? Would the formula work if I just specify the column number rather than using the column formula?
You're welcome and thanks for the feedback!
COLUMNS($B$2:B2) part is basically replacing the hard-coded column number in vlookup function. So when the formula is dragged from left to right the column number will dynamically change from 2 to 3 to 4, etc.
Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks