How do I check a cell 2 columns to the left of my current cell?

It seems like
=OFFSET(CELL("Address"),0,2,1,1)
Would work perfectly, but it gives me an error. I'm always coming up with scenarios where checking the cell (X,Y) of current position would be useful.

=INDEX($1:$1048576,ROW(),COLUMN()-2) computes, but does not give the desired result.
=OFFSET(D3,,-2) checks the right criteria, but isn't dynamic with regard to the cell reference.

Thank you for looking into it though.

I'm an idiot, I meant to say "to the right of the current cell". Therefor, =INDEX($1:$1048576,ROW(),COLUMN()+2) works perfectly. Thank you so much!