In Google Sheets, I'm trying to create a drop down that reads from 2 columns but returns from 1 column

by MiguelB718   Last Updated July 17, 2017 01:03 AM

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 ideas? thank you.



Related Questions