[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 482
  • Last Modified:

Vlookup and a Pivot Table

Hello,

I need to perform a basic division but using two different pivot tables. Pivot Table A represents number of stores with different values. The number of stores will fluctuate on a weekly basis (increasing or reducing). Pivot table B has the exact the same format but number of stores stays the same. Please refer to the attached file. Thanks!
Vlookup---Pivot-Table.xlsx
0
Ladkisson
Asked:
Ladkisson
  • 3
  • 3
1 Solution
 
NBVCCommented:
You say in the attachment if B3 Matches J3... do you mean linearly?  I.e. do you really want if B3 matches any store in column J?

Also how are store numbers to be entered in column R?
0
 
LadkissonAuthor Commented:
you can ignore column R for now...the goal is to match store numbers in both pivot tables. Pivot Table B will always stay the same. If Pivot table B has store # 737 but Pivot table A does not then there should be no calculations. Pls refer to row #  394. Hope this helps. Thx!
0
 
NBVCCommented:
So perhaps in S3:

=IFERROR(C3/INDEX(K:K,MATCH($B3,$J:$J,0)),"")

copied across and down.
0
2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

 
LadkissonAuthor Commented:
the formula gives me no values in return...can you pls attache the file so I can see what I am doing wrong? Thx!
0
 
NBVCCommented:
0
 
LadkissonAuthor Commented:
Perfect! Thank you!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now