I need to compare the prices at store 1, store 2, etc. I used a Min function to return the lowest price and now need to find the store name that has that corresponding price. I was going to use an Index-Match but keep getting #N/A. See rows 28-34 for specifics.
I couldn't find a solution that worked for me and am unsure as to what the issue even is, though I understand it can be a few things.
Note: there are multiple spaces between some data due to the descriptions of the items that will be in another column. Not sure if that makes a difference, but wanted to pass along all relevant info.
Thanks!
Bookmarks