I have been trying to create a search bar in Excel. I want to be able
to enter some letters into a cell, then have those letters be matched
with the closest resemblance in a range of text cells, and return the
number in the cell next to it. (I tried the LOOKUP functions, but if
the query is not exactly the same as the text in the array, it returns
the wrong value.)