In Google Sheets (GS), I set Data Validation for a range of cells (A1:A4) to reference the contents of another range of cells (B1:B4).
B1, Tom’s store
B2, Tom’s service
B3, Harry’s store
B4, Storage at Jane’s
In a cell in A1:A4, if I type “tom”, GS prompts with the list of:
Tom’s store
Tom’s service
I can then select the one I want.
In a cell in A1:A4, if I type “stor”, GS prompts with the list of:
Tom’s store
Harry’s store
Storage at Jane’s
Again, I can select the one I want.
With LO, I need to click the list arrow and then scroll through many possible hits. GS is much easier to use.
Is there a way to get LO to act like GS Calc?