VLOOKUP using absolute reference

[drop05]

Hello, i have this formula i am using

=VLOOKUP(L7,'List'!G5:P5,7,FALSE)

and i am trying to get it to where if it is copied then it would be

=VLOOKUP(L7,'List'!G6:P6,7,FALSE)

then

=VLOOKUP(L7,'List'!G8:P8,7,FALSE)

the same columns but one row down and so on. I was told about absolute reference
i believe if written like this it may work
=VLOOKUP(H7,'List'!$G5:$P5,7,FALSE)
however when copying it to another cell over it is not changing the row it is still 5 and not going to 6

any help would be appreciated thank you!

 

[Plukey]

Are you just dragging L7 down?

=VLOOKUP($L$7,'List'!G5:P5,7,FALSE)

 

[Fluff]

How about L$7

 

[drop05]

this does help for something else i did not think of but i think i worded my question wrong, after testing it actually worked good with =VLOOKUP(D$7,'List'!$G:$P,7,FALSE)

for some reason i thought that with =VLOOKUP(D7,'List'!$G5:$P5,7,FALSE)
i thought it would change to =VLOOKUP(D7,'List'!$G6:$P6,7,FALSE) when pasting to the right but it didnt

but with the reference im making in List it is referencing correctly

sorry for that and thank you for your help as well!

 

[Fluff]

Glad you sorted it & thanks for the feedback.