Two Vlookups to Return Text?

Alright, so what I am doing is referring to a pivot table with three columns Category, Impressions and Keyword. There are multiple Keywords for each category, so what I want is the keyword with the most impressions to represent that category. On another tab, I made a pivot with the Category and Max of Impressions and am trying to return the Keyword.

I have tried multiple things. I need more than one vlookup because some keywords have the same impressions, but are from a different category. Here's an attempt with a double vlookup:

Category Max of Impressions Max Keyword
A2 B2 =VLOOKUP(A2, 'Pivot-Weekly'!K:M, 3, FALSE)+VLOOKUP(B2, 'Pivot-Weekly'!L:M, 2, FALSE)

The tab it's referring to is:

Category (K) Impressions (L) Keyword (M)

I tried this too:
=IF(A2='Pivot-Weekly'!K:K,'Pivot-Weekly'!M:M,IF(B2='Pivot-Weekly'!L:L,'Pivot-Weekly'!M:M,""))

Thanks for your help you guys!

Anybody??

Try putting a sample so that others can see what you're saying, rather than people who wants to help visualizing it.

Here's a sample:

2 ways you can do it.

1st way is without the helper.

Please Login or Register  to view this content.

2nd way is with the helper.
In doing the 2nd way, create a column say in column J of 'Pivot-Weekly' Sheets and concatenate. i.e. in cell J2

Please Login or Register  to view this content.

then on Sheet1 of cell C2.

Please Login or Register  to view this content.

Thank you!!