Aug 31, 2015 at 12:04 PM
- Registration date
- Sunday September 12, 2010
- Last seen
- June 27, 2022
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.