I need some help with a better way to search the min/max value

Here´s the thing, I am an SEO Consultant and I am running a study where I compare the top 6 competitors from a client´s website, so many entries will be duplicates among the competitors and this is why I need help retrieving the min and max values from the Sheet2 into the Sheet1.

For example, the Sheet2 is the data from all 6 competitors but the data I am interested in are the ones shown in the Sheet1...

In Sheet1 - Max Vol (Col2) > This is the "Search Volume" metric int he Sheet2 (Col4)
In Sheet1 - Max Difficulty (Col3) > This is the "Keyword Difficulty" metric in Sheet2 (Col5)
In Sheet1 - Min Position (Col4) > This is the "Position" metric in Sheet2 (Col2)
In Sheet1 - URL (Col5) > This is the "URL" metric in Sheet2 (Col7)

This is Sheet1....

dafe70483c8238d5c1754c015b34c7ca.png

...and this is Sheet2...

bef533dbbaba143d3e3703ceaee6dcee.png

Thoughts?

Thanks in advance!!

Originally Posted by menem

I can't found duplicated data in sheet2.

but, please try this formula in sheet1

D2 (follow with ctrl-shif-enter for array formula)
=MIN(IF(Sheet2!$A$1:$A$201=$A2,Sheet2!$B$2:$B$201))

Regards.

That´s because the original data is over 5,000+ entries and as per the forum rules I can´t upload such a big file.

Hi xROGERx You allow permission to upload file extension and file size, please refer to this picture

Along with the details wk9128 has shown you can also upload an xlsb file upto 9.7MB

I missed one, it's very important, thank you @Fluff13 guru