Yesterday evening I have suddenly realized that I don’t have any photos to post for today edition of Photographic Fridays, I didn’t want this category to be a still born like the erstwhile Calvin fund 😀 So I took out the D40 and marched out of house in search a subject worth my clickitch.
While walking outside the apartment complex spotted this ominous looking traffic sign and I instantly knew what sepia tone could do to this. So there you go.
Now tell me, where do you want to go today? Left, Right or Straight ?
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.