Its Easter time. At Chandoo.org, I have tradition of publishing Easter Egg hunts since 2009. This is the first time our Easter egg hunt is on Power BI. Changing times, eh?
Find the Easter Egg in this report…
I have embedded the visual below. Can you find the egg? If you have difficulty seeing the embed, click here to access the report online, or download Power BI workbook.
Want more eggs? Check out previous Easter egg hunts
Go thru previous year hunts. Be warned though, they are highly addictive.
2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010 & 2009
and of course, Play hidden Angry Formulas game in Excel too
One Response to “How to compare two Excel sheets using VLOOKUP? [FREE Template]”
Maybe I missed it, but this method doesn't include data from James that isn't contained in Sara's data.
I added a new sheet, and named the ranges for Sara and James.
Maybe something like:
B2: =SORT(UNIQUE(VSTACK(SaraCust, JamesCust)))
C2: =XLOOKUP(B2#,SaraCust,SaraPaid,"Missing")
D2: =XLOOKUP(B2#,JamesCust, JamesPaid,"Missing")
E2: =IF(ISERROR(C2#+D2#),"Missing",IF(C2#=D2#,"Yes","No"))
Then we can still do similar conditional formatting. But this will pull in data missing from Sara's sheet as well.