Forum Discussion
Comparing Data from Two Excels - Most Views One & Most Engagements
DKoontz Thanks for pointing me in the right direction.
As I'm a newbie with , if you could provide me with a more in-depth explanation, I'd be most grateful.
I'll use two lists side by side so it'll be easier to show, but this will work across sheets too. So I would combine your two data lists using a look up, starting with this (your two sheets):
xlookup in column C =+XLOOKUP(A33,E:E,F:F,"") this transfers engagements from sheet 2, no matter what the order, and matches to the correct person or email in your case.
Select your data on sheet one and custom Sort:
Then add two sort by levels, first by views largest to smallest, then engagements largest to smallest:
I'm able to partially set up the LOOKUP, but I can get the formula to go through. I set up the sheet like this, but keep getting a "#NAME?"
Then I've tried multiple formulaS in C3 for the column C: "=Xlookup(A3,E3:E35,F3:F35)" ; =+LOOKUP(A3,E:E,F:F) . Nothing is working. Can you tell where I'm missing something?
As a comment, discussion could much more efficient if share sample file, not screenshots. "Nothing is working" is too abstract. Screenshot says only that XLOOKUP() is available in your environment. But returns result which you don't expect, and from screenshot is not clear which one. #NAME! error could be caused by few reasons, without the file it's long discussion to understand by which one exactly.
I know XLOOKUP works with the web version of Excel, as for desktop versions, I think it is available from Office 2019 onwards.
The alternative is VLOOKUP, Syntax: VLOOKUP(<value to lookup>, <range of data with lookup field on the left of the range>, <column number to of the range to return>, FALSE). The lookup value must be in the first column of the range.
Example based on your data:
A B D E F 1 SN Name SN Leads Saved SN Name Result 2 Yago 641 Mal 314 3 Michael 327 4 Mal 314 In the example above, the cell in F2 has =VLOOKUP(E2,A2:B4,2,FALSE). A2:B4 is the range to look up the value with 2 being the 2nd column of the range. The False on the end dictates if you want an exact value or the closest match (False = Exact Match, True = Closest Match)
