Aravind (@arvindnatarajan) who works at Zoho emailed me earlier today and asked if Zoho Reports – Online Reporting and Business Intelligence Service, can sponsor our visualization challenge #2.
I couldn’t be happier to see that mail. Zoho is a perfect sponsor for a contest like this. If you haven’t heard of it, Zoho is a very popular online office solution. They have a collection of over 20 different productivity applications including zoho sheet, writer, show, projects, CRM, reports and much more. Check out more about online reporting and BI services on the Zoho Reports page.
What are you waiting for? Go ahead and take part in the contest, download the data and get charting.
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.