Link to home
Start Free TrialLog in
Avatar of asc2010
asc2010

asked on

How To Use VLOOKUP or INDEX Across Two Excel Files

I have two Excel files, each with a list a US States, their abbreviations, and 3, non-adjacent columns of data I would like displayed in file A from file B.  I will attach the files I am working with.

In FileA, the columns should match the data in the corresponding columns in FileB based on the listed state.

FileA.xlsx
FileB.xlsm
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of steverice
steverice
Beat me to it Brad, but here's the files anyway....

FileA.xlsx
Avatar of asc2010
asc2010

ASKER

byundt:

Awesome!!! Thank you so much, it works perfectly!
Avatar of byundt
byundt
Flag of United States of America image
If you do copy the formula across, you'll need to add a $ for the state abbreviation column and the very beginning of the formula:
=VLOOKUP($B13,'[FileB.xlsm]United States'!$B$7:$U$58,MATCH(D$12,'[FileB.xlsm]United States'!$B$6:$U$6,0),FALSE)

The header label in cell D12 must match exactly one of the header labels in row 6 of FileB. If not, you'll get #N/A as the result of the formula.

Brad