Match - #N/A

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!

Originally Posted by prosemur

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!

Sorry, forgot to attach on original post.

This is great, thank you!

Any idea why the #N/A shows up? I couldn't figure it out for my sheet.