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!
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!