-
– During formula typing, adjusts the reference type, abs to relative, otherwise repeats last action
-
+
– Inserts current date -
+
– Copies value from cell above to current cell -
+
– Edits a cell comment -
+
– Opens macro dialog box -
+
– Auto sum selected cells and places value in cell beneath -
++
– Currency formats current cell -
++
– Applies outline border to selected cells -
++
– Comma formats current cell -
++
– Activates font drop down list -
++ – Activates font point size drop down list
– During formula typing, adjusts the reference type, abs to relative, otherwise repeats last action
+
– Activates font point size drop down listWhat is your favorite keyboard shortcut / productivity tip?
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.