Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 487
  • 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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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