excel - Need to match data in different sheets and replace data in another cell if it's a match -


i need match data in column a2 , on in sheet 1 data in column a2 , on in sheet 2. if data in column of sheet 1 , sheet 2 match need data in column b & c of sheet 2 replace data in column b & c of sheet 1. know little doing kind of stuff appreciated!

sheet 1

         b     c 2  12345  5.35  9.95 3  15874  4.22  10.99 4  11111  2.24  5.99 5  98745  5.33  9.95 6  88552  4.24  8.95 


sheet 2

         b     c 2  11111  2.09  5.79 3  12345  5.11  9.89 4  88552  4.01  8.79 


need sheet 1 change to

         b     c 2  12345  5.11  9.89 3  15874  4.22  10.99 4  11111  2.09  5.79 5  98745  5.33  9.95 6  88552  4.01  8.79 

on third sheet use these functions

column ='sheet1'!a2 column b =if('sheet1'!b2='sheet2'!b2,'sheet2'!b2,'sheet1'!b2) column c =if('sheet1'!c2='sheet2'!c2,'sheet2'!c2,'sheet1'!c2) 

copy sheet3 , paste values sheet1. should work unless column match. or if need dynamically. if column doesn't match vlookups can thrown in.

i data match in column formulas this.

column ='sheet1'!a2 column b =if(not(iserror(vlookup(a2,'sheet2'!a:c,2,false))),vlookup(a2,'sheet2'!a:c,2,false),vlookup(a2,'sheet1'!a:c,2,false)) column c =if(not(iserror(vlookup(a2,'sheet2'!a:c,3,false))),vlookup(a2,'sheet2'!a:c,3,false),vlookup(a2,'sheet1'!a:c,3,false)) 

Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -