Is there a way to look up a name OR number in a data validation list but only let the user select the number and then have the associated number populate in the adjacent cell?
My goal is for users in a file to be able to see the project numbers and/or names (some users search by names and some...