Validated List Entry But Only Return/Make Visible Part of the String Result?

I have a validated list of employee names and ID numbers. Because of the way the existing form I'm trying to update is formatted, I need to pull the ID # into column A and the Name in column B. In order to have a searchable validated list that goes by name or #, I would like to have the validated list main column be "FirstName LastName - #####-###" which is first name last name and 8 digit employee ID. I would like this list to be the validate result in column B in my form, however column B in the form is just employee name so I would like the returned result to NOT make the ID string part of the result visible, just the name. column A will then return the ID based on a lookup back to the table (it could also be validated in column A where he ID shows and the name does not).

The reason for this is so that the user can start searching to pull up an employee by either ID or name in case one or the other is known.

Is there any way to make this happen without VBA? I'm thinking maybe not at this point. In a perfect world excel needs to add some functionality where you can have 2 or more fields that otherwise would have a key field and lookup fields, but you can enter in any of the 2 or more fields and the others dynamically populate based on the one you entered (and it would need to live update if you entered a new value in one of the fields by changing the others).

Thanks,