Ok, this is *totally* exciting. I am big fanboy of Garr Reynolds of Presentation Zen. His blog is one of the very first blogs I have started reading and I still read it whenever there is a new post. Few days back I saw on his blog that he is coming down to Malmo, Sweden for a keynote presentation at FBTB Conference.
My first reaction?
I went to the FBTB site to find out if I can attend the conference. But I learnt that the sessions are on Thursday and Friday (I am working on those days) and they cost 1,100 euros (gulp…).
But I thought… “may be I can get a chance to meet Garr and probably interview him”
So today morning I emailed him and asking if he can give me 15 minute interview. And guess what…
So here is your chance to share my excitement and ask a cool question to Garr.
The interview theme is “Charting Zen: Designing Better Charts and Telling Interesting Stories”
Drop a comment or tweet me @r1c1 with your questions. Hurry!!!
PS: Watch Garr’s presentation @Google on youtube or read his Presentation Zen book
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.