V-lookup in Pivot Table

**kisboros** · 04-17-2012, 05:53 PM

Dear Gurus,
I have attached a partial workbook for this problem. How would I do a vlookup by customer code so that it puts weights in column D of "Customers" tab, considering individual routes. It means that a customer code may show up in several routes.
Thank you!

**micope21** · 04-17-2012, 06:06 PM

Hi
Try this
D2 =INDEX(Pivot!$C$2:$C$26, MATCH($C2, INDEX(Pivot!$B$2:$B$26, 0), 0)) then copy down

You need to type in again c2 to c26 in order to work.

**micope21** · 04-17-2012, 06:49 PM

If you want a V lookup

You on excel 2007
Try this

D2 =IFERROR(VLOOKUP(C2,Pivot!$B$2:$C$26,2,FALSE),"") then copy down

**kisboros** · 04-17-2012, 06:56 PM

Where do I need to type the pivot range again? Maybe thats the reason that the formula only partially worked. It pulled rows 2,3,4,5,and 13 only.

**kisboros** · 04-17-2012, 06:59 PM

I am getting a "name?" error.

**micope21** · 04-18-2012, 02:27 AM

Reason "name?" come up cos you are using excel 97-2003 file instead of excel 2007 show on your My Profile.

All info are in the file. Please click on attachment.

Cheers

**kisboros** · 04-18-2012, 11:02 AM

Originally Posted by micope21

Reason "name?" come up cos you are using excel 97-2003 file instead of excel 2007 show on your My Profile.

All info are in the file. Please click on attachment.

Cheers

My bad. Sorry. I am at a client's business and they are on 2003. Thank you very much for the help. It works now.