Hi,
I am trying to use wildcard both in front and behind the lookup value of C3 so that the formula would be able to find "Pizza place A" and returning the price "5" by looking for "place A with wildcards but for some reason it is not working.
See attached example.
Please advice
Bookmarks