That aint a new aJAX based web service or a community site for head_scratchers_with_left_hand_middle_fingerers or something. Be warned.
My computer, Madhu as I call it got a major upgrade two days ago. The 6 year old marathon win2k, p3, 256mb, cd rw system is now a spanking new p4 3ghz, 512 mb ddr, 160 gb sata and dvd rw system with windows xp. I was really depressed to see the old with all the capacitor junk and infuriatingly long start-up delays. I think this config should keep me current for atleast 2007.
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.