Chris,

Dynamic Data Validation of type list would do this.

Given a list with sorted search terms called Terms and a cell F4 with
data to use

Use the following formula as your list validation:

=OFFSET(Term,IF(ISNA(MATCH(F4,Term,1)),1,MATCH(F4, Term,1)+IF(ISNA(MATCH(F4,Term,0)),1,0))-1,,IF(OR(ISNA(MATCH(F4&"z",Term,1)),F4=""),ROWS(Te rm),MATCH(F4&"z",Term,1))-IF(ISNA(MATCH(F4,Term,1)),1,MATCH(F4,Term,1)+IF(IS NA(MATCH(F4,Term,0)),1,0))+1)

Note that you can even create your validation list *on* F4, but then
you need to disable the error warning.

Looks almost professional:)

Dm Unseen