#1
|
|||
|
|||
Lookup and replace cell values
Hello -
I have 2 worksheets that contain data I would like to cross-reference from one worksheet and use to replace or add values to in another. Win7 64-bit and Office 2013 In one worksheet I have 2 columns labeled Vendor_Name and Vendor_ID. The Vendor name is just that, like ACME, INC and the Vendor ID is the corresponding ID number for that vendor, such as 1234 The other worksheet has the same Vendor_ID column but not a Vendor_Name and I would like to find a way to either - 1) Replace the Vendor ID number in the Vendor_ID column on the second worksheet with the matching Vendor_Name on the first worksheet, or - 2) Add a new column next to the Vendor_ID column with the matching Vendor_Name from the first. I can't do it manually as there are over 2600 entries. In the attached XLSX Sheet - Sheet 1 / column A contains the Vendor ID number and column B on Sheet 1 we also see the vendor name. Sheet 2 only shows the ID number. The numbers are not sequential like you see in this example or I would just copy and paste that column in! Any thought on how to populate the missing Vendor name will be most appreciated! |
#2
|
|||
|
|||
Hello & Welcome to the Forum,
On sheet2 in B2 copied down.... ...I think you are looking for =VLOOKUP(A2,'SHEET 1'!$A$2:$B$10,2,0) |
#3
|
|||
|
|||
Oh my gosh, that's it, works fine, Thanks very much and have a great day!
|
#4
|
|||
|
|||
You are very welcome. Glad you have something to work with and thanks for the feedback.
Last edited by jeffreybrown; 10-03-2016 at 07:08 PM. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
LOOKUP - Complex lookup with 2 lookups in 1 cell | sglandon | Excel | 6 | 05-05-2016 09:44 AM |
using two lookup values to get a sum figur | Ian A King | Excel | 3 | 05-18-2015 02:56 PM |
Lookup / Paste Multi Values VBA | Mav | Excel Programming | 6 | 05-10-2015 08:42 PM |
Lookup multiple values and compare different scenarios to get a specific result | mws | Excel | 5 | 05-24-2014 04:52 AM |
How can match or lookup values from two separate tables? | klawk26 | Excel | 1 | 07-31-2012 09:04 PM |