Simple story - driving me cray cray.
I have a single Google Workbook with sheets within with separate names (Sheet1
, Sheet2
, etc).
I have a separate sheet called Compare
that I want to make formulas for each cell such that I can check if there is a difference between the cells on different sheets. For instance:
=IF(Sheet1!G4<>Sheet2!G4,Sheet1!G4&" | "&Sheet2!G4,"")
But I will use dropdowns on L2
and L3
, so now I would assume I could do:
=IF(indirect(L2&"!G4")<>indirect(L3&"!G4"),indirect(L2&"!G4")&" | "&indirect(L3&"!G4"),"")
in my comparison sheet on cell G4
.
Problem is that this is ONLY for matching for cell G4
.
How do I make the reference malleable so when I copy down, the ROW number changes, and when I copy right, the COLUMN reference changes?
I have tried to convert the cell reference into a text, but have not found a way to do it.
Any recommendations? Thanks for any help.