Home

How do I automatically fill columns based on cell value from another excel file?

ethrande
Occasional Visitor

I have a column filled with organization names in one excel spreadsheet (the same name is often repeated or occurs multiple times). In another spreadsheet, I have a sort of a code-book for these organizations. In the second file, the exact same names from the first file (duplicates removed) have corresponding cells in their row with additional information (i.e. what type of industry they are in). I would like to go back to the first file and add this information in based on their names. Is there a way to automatically add info into new columns automatically? 

1 Reply

Hi - You have to use a Vlookup formula. An example is on the attached file.

 

The workbook assumes that the "File 1" sheet is your 1st file and the "File 2 - Code Book" sheet is your 2nd file.  You would have to put the formula in Column b of your first file (the file with the duplicate values). Your lookup range will be on your second file (the file with the unique names and code book). Please let me know if this helps.

 

Here's the formula used in the file: =VLOOKUP($A2,'File 2 - Code Book'!$A$1:$B$7,2,FALSE)

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies