Function For Auto Filter / Predictive Text

[BSLAUTOMATION]

I have a cell that looks up column A (suppliers) on another work shee
and returns all details for that supplier. I need something that aut
fiters column A as i type due to the bad spelling of suppliers names.
I know it can be done in access but dont know how in excell, can anyon
help

 

[Frank Kabel]

Hi
I'd use data validation (creating a drop down listbox) for your first
column and VLOOKUP for the other columns to get your data. See the
following sites for more information:
http://www.contextures.com/xlDataVal01.html
http://www.mvps.org/dmcritchie/excel/vlookup.htm