Autofilter VBA but also show product prices from other shop

[rksingh2020]

Is there any way in autofilter show same products from other stores too , so comparison get easier.

[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.

[rksingh2020]

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

[rksingh2020]

Thanks for your help.

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


Store Prodcut Price Other store Composite
Amazon Iphone 48258 Amazon Amazon:Iphone
Iphone 50678 Babyoue Babyoue:Iphone
Iphone 54252 First Cry First Cry:Iphone
Iphone 45736 Flipkart Flipkart:Iphone
Iphone 52107 Indiamart Indiamart:Iphone
Iphone 54241 Infibeam Infibeam:Iphone
Amazon Priv 54347 Amazon Amazon:Priv
Priv 46449 Babyoue Babyoue:Priv
Priv 45878 First Cry First Cry:Priv
Priv 47948 Flipkart Flipkart:Priv
Priv 47288 Indiamart Indiamart:Priv
Priv 56733 Infibeam Infibeam:Priv

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.