Ok, I can't seem to find the answer to this anywhere.
I have a table of data, specifically from google search console
Let's say it looks like this:
What I need help with is a vlookup (or index it seem may be an option) that if I get a match on Query it will return the lowest position on that query match AND it will return the page associated with the lowest position
So In my table it should be
And the result, based off the data my first table would look like:
I wouldn't even mind using a pivot to get that information FIRST and then doing the vlookup off that table, but I can;t seem to figure out how to show only one result of page based off the min value of query.
ANY help here would be greatly appreciated.
I have a table of data, specifically from google search console
Let's say it looks like this:
Query | Page | Clicks | Impressions | CTR | Position |
keyword | MrExcel | 6,833 | 160,725 | 4.25% | 4.2 |
keyword | https://www.website.com/subpage/ | 6,236 | 43,563 | 14.31% | 2.1 |
keyword two | https://www.website.com/subpage/ | 2,844 | 24,975 | 11.39% | 3.2 |
keyword two | https://www.website.com/subpage/subpage | 2,303 | 20,957 | 10.99% | 2.4 |
What I need help with is a vlookup (or index it seem may be an option) that if I get a match on Query it will return the lowest position on that query match AND it will return the page associated with the lowest position
So In my table it should be
Col A | Col B | Col C |
keyword (the lookup value) | formula for returning lowest position | formula for returning the page associated with lowest position |
And the result, based off the data my first table would look like:
Query | Position | Page |
keyword | 2.1 | https://www.website.com/subpage/ |
keyword two | 2.4 | https://www.website.com/subpage/subpage |
I wouldn't even mind using a pivot to get that information FIRST and then doing the vlookup off that table, but I can;t seem to figure out how to show only one result of page based off the min value of query.
ANY help here would be greatly appreciated.
Last edited by a moderator: