I have one workbook. 2 sheets. Sheet 1 has inventory items in column A and the price for each item in column B. On sheet 2 I have items in column C. Right now items has a dropdown that references column A on sheet one. What I would like to do is just start typing an item into a cell and have it suggest the closest match from column A on sheet one, instead of having to scroll through a dropdown.
