how to replace data from one cell with information from another

[wpbman]

I have a large file - 50,000 records.

I am trying to match up data. Its an export from a CRM. One file is contacts, and other is Accounts. Each has a RECORD ID field, which I am trying to key on.

I merged the two, but where i am running into trouble is trying to do a find and replace. If cell c3 has Record ID 12345, I want to replace it with the corresponding company name for the record ID - XYZ company. These would be row D (record ID) and Row E (company Name)..............

I am trying to get it to populate the company names into the record ID field - right now it just shows TOM JONES Record ID 12345, what I want it to show is TOM JONES XYZ Company.

So its a detailed find and replace on a macro scale as there are 34,500 record IDs which will be replaced into 56,000 records to show the corresponding company name for the contact.

Hope this makes sense!

I have tried IF THEN statements, MATCH Formulas all for naught. I hope I dont need a macro as I am a wimp when it comes to those!

Thanks in advance for any and all help!

 

[Sandeep Warrier]

Hi and welcome to the board!!

If you want to replace a cell's value with a new one you will need macros. If you want to work with formulae, use a helper column. I think you should get your data using Index/Match or Vlookup. Once you have your required data, copy the entire column and do a Paste Special -> Values in the required column.

Try any of the following (adjust ranges to suit needs):

=VLOOKUP(C3,$D$3:$E$50000,2,0)

OR

=INDEX($E$3:$E$50000,MATCH(C3,$D$3:$D$50000,0))

<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">