For example in the item column (F4), I want to be able to type in 'Baked' and in the count column (G4), type 30. Then I want a formula in the Price column (H4) to lookup and return the Price for Baked Chip 30 CT.
Another example if I type in item Cereal Bar and count 48 return the price 9.82 for Quaker Cereal Bars 48 ct.
Then if it can also take abbreviations for what I type like if Item Hersh Alm, count 36 return the price 17.82 for Hershey Almond 36 ct.
I prefer it not to use any visual basic code as I will be running the program from my phone that doesn't support it.
Thanks in advance!
p.s. If partial lookup absolutely can't be done for item column then how to do exact match.
Bookmarks