- Registration date
- Sunday September 12, 2010
- Last seen
- October 22, 2020
Good thing you stopped after manually inputting 4 rows.
VLOOKUP is the formula you are looking for. Write 1 formula for the D column and one for the E column and then drag both down.
Do let us know if you can't get it to work.