“Lakdi Ki Kathi”, that is probably the first song that I have ever heard, at least its the one that I can vividly remember hearing. On one sunday (or some such holiday when I didnt have to go to school) my dad played this song on our cassette player, the kind with a speaker and cassette slot are on the top. He put it near the kitchen so that my mom could hear it while cooking and he could hear it while he is shaving. I must have sang “lakdi ki kathi” several times when I was very young.
Today during some usual browsing I came across this and instantly felt very happy 🙂
What is the first song you ever heard?
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.