For FileA cell D13, you could use a lookup formula like:
=VLOOKUP(B13,'[FileB.xlsm]United States'!$B$7:$U$58,MATCH(D$12,'[FileB.xlsm]United States'!$B$6:$U$6,0),FALSE)
If the lookup table in FileB contained
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.