Converting Data from ID to Another

casey03

New member
Joined
Feb 21, 2015
Messages
2
Reaction score
0
Points
0
Hi All,

I am new when it comes to Excel. I have 2 spreadsheets that I am trying to compile into a single sheet, but the data columns don't match so i can't do a simple copy and paste. I will give an example Below to help try and explain what I am looking to do.

I need to convert the Pro_ID in Book 2, to match the Pro_ID in Book 1, but leaving the UPC numbers in Book 1 alone. I think it would work like..... IF BOOK 2, COLUMN A MATCHES BOOK 1 COLUMN B, REPLACE WITH BOOK 1 COLUMN A DATA (SAME ROW)

Book 1Book2
COL ACOL bCOL A
1PRO_IDUPCPRO_ID
2AAA11111111
31111
41111
5BBB22222222
62222
7CCC33333333
8DDD44444444


If it can be done, I will need really simple how to steps to complete this. There are 6000 Pro_ID's so this one at a time is not easy.

I am not sure how best to explain what I am trying to do... All i know is, I need the IDS in COL A Book 2 to convert to the IDS in COL A Book 1

Thanks in advance
 
Last edited:
I can do a simple Find & Replace. So find AAA and Replace 111. That works fine for 1 ID. I Would like to be able to do it in bulk.
 
Try

=IFERROR(INDEX([Book1]Sheet1!$A:$A,MATCH(A2,[Book1]Sheet1!$B:$B,0)),"")
 
Back
Top