We went to Hocking hills state park during the weekend, hiked a few miles, had tons of fun watching waterfalls, caves, cliffs, rare plants and infinite greenery. The trip has been thoroughly grinding with almost every place looking spectacular and lengthy. We couldn’t really visit all the attractions as both of us were feeling totally tired after what felt like 10 miles of hiking.
I had great time testing our new
Nikon D40 though, some of the shots came really well, at least thats what I thought. Share your feedback so that I can become a better clicker.
Spotted this while hiking, any idea what they call this?
flowers and a bee
Sharp and a wood block
Happy week ahead!
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.