pulling multiple columns into a spreadsheet by matching on one column

Occasional Visitor

I want to index multiple columns and match on one criteria. my example is: I have one spreadsheet with emplID, name, address 1, city, state, zip columns. the other spreadsheet has emplID. I want to bring over the name and all address fields by matching the emplID. how do I do that

1 Reply


You can try Power Query. The blue tables in the attached file are dynamic tables. In the large blue table you can enter data. In the small blue table shown in the screenshot you can select the empID for which you want to pull information. Then click in any cell of the green table and right-click with the mouse. Then select refresh.

pulling multiple columns.JPG