Images are below. Three tabs: 1) Report, 2) Store Vol, 3) Community Days.
J53 on Report is where the return value will be. Currently, in that cell is a combination of a VLookup and an HLookup. The Vlookup is pointing to A53 where a 1 is located to indicate Store #1 . It then finds Store #1 in...