I am doing Business pricing for a Bar, and I was hoping for some help in getting the prices from websites to fall into the excel spreadsheet and then tell me which is cheapest. I have mostly worked out how to with just one bug; so any help would be appreciated. I have attached picture of the spread sheets and formulas I have used.
As you can see from the 3rd row, the formula isn't working as Bob's is cheaper than Dan's and the formula shows Dan's.
Anything that would make this better or easier would be help. Possibly thinking of adding an extra store to price check against