Basically, I have store number and Store name. I want to be able to start typing a name and select the name, but only show the store number.

If that is not possible, then I thought I can combine store number "-" name and then upon selection i should be able to Lens to the before "-".

Any idea?


Data validation drop drowns in Google Sheets can't pull data from two columns.

One solution is the one that you already figured out, join the values of those columns and the use those joined values.

Not the answer you're looking for? Browse other questions tagged or ask your own question.