Multiple Find/Replace

BoyMom826

New Member
Joined
Dec 11, 2020
Messages
15
Office Version
  1. 365
Platform
  1. Windows
Hello!

I am merging a sheet from last year with one from this year to pivot out YOY data. Last year's districts are listed differently than this year's.
My need is:
If the district number (column F) matches the district listed in column H, I will need it to give the value of I to column G.

There are 1,333 values in column F and 140 in column H/I, so I will need column G to reflect the value in the same row as H if that makes sense. Here is a picture for reference. I did a few manually through find/replace, but am finding it to be tedious and would like to have formula to finish!
 

Attachments

  • Screenshot 2020-12-11 123400.png
    Screenshot 2020-12-11 123400.png
    43.6 KB · Views: 4

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Hi BoyMom826,

You could insert a new column, apply this formula then copy the new H column contents and paste as values to column G

BoyMom826.xlsx
FGHIJ
1DistrictOldFormulaNewNew
210JimBert10Bert
344SueSarah111Bob
4111BobBob33Harry
510JimBert32Frank
644SueSarah99Mike
780BertBert44Sarah
810JimBert20Sue
944SueSarah333Kim
1055TomTom222Luke
Sheet1
Cell Formulas
RangeFormula
H2:H10H2=IFERROR(VLOOKUP(F2,I:J,2,0),G2)
 
Upvote 0
Solution
Hi BoyMom826,

You could insert a new column, apply this formula then copy the new H column contents and paste as values to column G

BoyMom826.xlsx
FGHIJ
1DistrictOldFormulaNewNew
210JimBert10Bert
344SueSarah111Bob
4111BobBob33Harry
510JimBert32Frank
644SueSarah99Mike
780BertBert44Sarah
810JimBert20Sue
944SueSarah333Kim
1055TomTom222Luke
Sheet1
Cell Formulas
RangeFormula
H2:H10H2=IFERROR(VLOOKUP(F2,I:J,2,0),G2)
Thank you! This did exactly what I needed. Much appreciation!
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,202
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top