- Registration date
- Sunday September 12, 2010
- Last seen
- April 1, 2021
Make 1 value out of the First and Last name cells. Like =A1 & C1 for sheet1. You can hide this column.
Now you can use VLOOKUP to find the First Last Userid value. Make sure that the concatenated column is to the left.