Excel Formula - VLOOKUP and MATCH

All, I have a formula that kind of works but for some reason its pulling the names from the array into the first column.

=VLOOKUP($A2,Sheet2!$A$5:$K$175,MATCH(Sheet3!B$1,Sheet2!$B$4:$J$4,0))

I am just trying to match the totals under the dates in the VLOOKUP table that I made. The only problem in my first column it matches the names instead of giving me the totals, but after the first column the totals appear. I cannot share the data since its confidential.
LVL 19
Edward PamiasTeam Lead RRS DeskAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bill PrewCommented:
Can you share a sample workbook?


»bp
0
Edward PamiasTeam Lead RRS DeskAuthor Commented:
I can tell you this. I have sheet 2 with my pivot.... name column starts at A5, after that on the pivot I have 8 more columns with dates B4 - I4, On Sheet 3 a list of names A2 on down, and A1 - I1 has the dates. So on Sheet3 is where I want to populate the data from Sheet 2. The data should correspond with name and date.
0
Edward PamiasTeam Lead RRS DeskAuthor Commented:
Bill, this is it on a smaller scale minus the pivot.
sampleBook1.xlsx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Edward PamiasTeam Lead RRS DeskAuthor Commented:
The sheet with no values is the one where I want the formula.
0
Bill PrewCommented:
Okay, let me take a look at those, thanks.


»bp
0
Bill PrewCommented:
Take a look at this and see if you can adapt it.  I needed to add +1 to the MATCH() result to get the right column selected by VLOOKUP(), and also added the last parm to VLOOKUP() to indicated an exact match desired bu the lookup.

sampleBook1.xlsx


»bp
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Edward PamiasTeam Lead RRS DeskAuthor Commented:
That was it Bill, I took that +1 and the ,false) and that fixed. You da man! :))
0
Edward PamiasTeam Lead RRS DeskAuthor Commented:
Thanks again!
0
Bill PrewCommented:
Great, glad I was able to help.


»bp
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VB Script

From novice to tech pro — start learning today.