Auto populate cell based on another cells data

**shapmb** · 08-04-2014, 02:16 PM

Hey guys (and gals),

I am trying to simplify a process that usually requires me to look up data from another worksheet and copy/paste.

What I'd like to do is start using a master copy of an excel file that will auto populate the "company name" field based on matching the "vendor id" column (A) with the "vendor id" column (L). Both L and M will be static and not change much. The table to the left of L/M will be updated monthly. What I'll be doing is copying the vendor ID's from another pivot point sheet into column A and hope to have the company name field auto-import based on M.

sample.png

See attachment.

I appreciate any guidance with this! It will be a huge time saver.

Thanks!

**Jonmo1** · 08-04-2014, 04:16 PM

Try Vlookup

Make sure C2 is formatted as General First.
Then In C2 and filled down, put
=VLOOKUP(A2,$L$2:$M$5,2,FALSE)

**shapmb** · 08-04-2014, 06:02 PM

Brilliant. Worked like a charm. I've expanded "M$5" to "M$1000" to accommodate additional ID's and Names. Thanks you very much. I need to take some tutorials on Vlookup.

**tomaustin** · 03-17-2015, 12:40 AM

I have a similar issue but I want to auto populate various data fields in one sheets based on information in another sheet. I have read various posts on the forum and I have tried various VLOOKUP formulas but I can't get it to work. Attached is an example of the file. The master data file is in sheet 2. Whenever we enter a store number on sheet 1 we would like for the rest of the data for that store to auto populate in sheet 1. Any guidance would be appreciated. Thanks !

Specs_Store_Info_2015-1.xlsx

**tomaustin** · 03-23-2015, 09:45 PM

Can anyone assist in the above matter ? Thanks !

Auto populate cell based on another cells data

LinkBack

Thread Tools

Rate This Thread

Display

Auto populate cell based on another cells data

Re: Auto populate cell based on another cells data

Re: Auto populate cell based on another cells data

Re: Auto populate cell based on another cells data

Re: Auto populate cell based on another cells data

Thread Information

Users Browsing this Thread

Similar Threads

Excel 2007 : Auto-populate cells based on value in another cell

Help: How do I have a drop-down cell auto-populate other cells based on result?

[SOLVED] Can I Auto populate cells based on value in another cell

Auto-populate cells based on data from another sheet

Auto-populate cell based on values in other cells

Bookmarks

Bookmarks

Posting Permissions