Help with repeating formula automatically adjust cells

[Bazoogle]

I really can't word this well, so I'll explain what I mean.

I have 2 sheets, the first one you manually type things and the 2nd formats it into a certain way. The first sheet is setup vertically with names being the rows, and the formatted sheet has the names as the columns.

To format the 2nd sheet I have something like this setup:

Cell C1:
=IF( Sheet1!L19 = "", "", "hello" )

I want cell B1 to be
=IF( Sheet1!L20 = "", "", "hello" )

but instead it makes it K19. I already tried $L19 but it makes all cells $L19. How can I set this up so it does what I am trying to do?

 

[Bazoogle]

If you aren't sure, it would still help a lot if you were to put into words what I am trying to do. I can't seem to search for the answer because I don't know how to ask

 

[Bazoogle]

I was able to figure out a solution. After googling many different odd statements, I cam across this:

https://www.brainbell.com/tutorials...ment_By_Rows_When_You_Copy_Across_Columns.htm

Thought I'd add it in the event someone down the road is looking for the same thing.