Forum Discussion
Comparing Data from Two Excels - Most Views One & Most Engagements
I have two excel sheets. One, I've sorted by "most engagements" and the other sorted by "most views." Each sheet has the same emails for each employee. I'd like to compare data from the t...
No problem! I see where the mistake was, in your formula you have =+Xlookup(A3,E:E:F:F), it should be =+Xlookup(A3,E:E,F:F), you had an extra : where it should have been a comma. If you fill down this formula, it'll bring over all of the shares for each person. Where it returns an #N/A, that person isn't represented in column E, the share data set.
To add to this, =+XLOOKUP(A3,E:E,F:F,0), the extra 0, will return 0 if not found instead of #N/A. Which may be helpful
Excel 2016 doesn't support XLOOKUP(). Formula like this could work
=IFNA( INDEX($F3:INDEX($F$3:$F$10000,COUNTA($E$3:$E$10000)), MATCH($A3, $E3:INDEX($E$3:$E$10000,COUNTA($E$3:$E$10000)), 0)), "no match")Please check attached.
