So I have this data set of locations and their net sales that I download as an excel file, but it labels the location names in an unfavorable way. I want to be able to paste the data set that I downloaded into a "box" and then my other "boxes" would fill automatically to the corresponding location name.

I made an example of what I'm doing.
Booth 1 = MLocation-B1
I want to be able to paste the "MLocations-B#" into the box and the formula would find the MLocation-B1 and then return the Net Sales adjacent to it into the "Booth 1 Net Sales"

I want to do this weekly so it would be great if I was just able to download it and then paste it.

Thank you!


HELP-IfRange.PNG