Can Excel create suggestions based on a range of cells?

[Philanalyst]

I have a simple spreadsheet with two columns - one column is an alphabatized list of common expenses (adapters, advertising, architectural Services, etc.) the other column has the corresponding account numbers these items should be coded with.

I want to create a cell into which you can enter text and suggestions will appear. I see that Excel will suggest an auto fill when you have entered characters unique to only one expense description, but this is not helpful. ex. 'Books' and 'Books purchased for registration of a class' are two separate decriptions. If I type 'books' i get nothing, because there are more than one description that start this way. If I type 'Books_', then I will get 'Books purchased for registration of a class', but will never see 'Books', which has a different account number.

Anyway this can be done? I suppose people could use the 'find' function, but I fear not everyone here is that "advanced".

Thanks

[Palmetto]

Why not use Data Validation with the List Option to provide users a means to select only valid entries? This requires no coding and can be very effected when used correctly.

Optionally, with some VBA coding, you could use a list box control that will match a selections as you type entries.