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
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.

IT / Software Engineering ConsultantCommented:
Can you share a sample workbook?

»bp
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.
Bill, this is it on a smaller scale minus the pivot.
sampleBook1.xlsx
The sheet with no values is the one where I want the formula.
IT / Software Engineering ConsultantCommented:
Okay, let me take a look at those, thanks.

»bp
IT / Software Engineering ConsultantCommented:
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

Experts Exchange Solution brought to you by

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