I most commonly use vlookup on text data. Often, this results in returning the wrong information; it seems to default. Also, empty cells are a problem It has occurred to me, given the great (and really fast help) I've found on this site, there may be a better way to do this other than using vlookup.
I have item names A through Z. I have a table of prices for these items. Currently I have an item name in cells A1, A2 and A3 and a formula that looks up the name in each of those cells and adds the resulting values together. This does not allow me to have no entry in one of the three cells (which logically, returns #NA) and also returns a false answer if the item name input is slightly misspelled.
Suggestion gratefully accepted.
Bookmarks