Autofilter VBA but also show product prices from other shop

I'm taking some guesses as to what you want. It seems that the price is based on the store and the item. So I combined them into what I call a composite key. That is I took the strings and concatenated them together. I stuck a colon ( in the middle to make it more readable.

Then I looked up the information using INDEX and MATCH using the composites.

Originally Posted by dflak

I'm taking some guesses as to what you want. It seems that the price is based on the store and the item. So I combined them into what I call a composite key. That is I took the strings and concatenated them together. I stuck a colon ( in the middle to make it more readable.

Then I looked up the information using INDEX and MATCH using the composites.

Thanks for your help.

But I need to see data like this (if in datavalidation -list select , i selected store Amazon in Cell A1;


Image.png

So while excel will pull iphone price from Amazon first, but for comparison it will show prices from other stores too before pulling Amazon priv product/other data