- Registration date
- Sunday September 12, 2010
- Last seen
- August 3, 2021
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.