VLookup Formula not copying down correctly

[klane8870]

Using the following formula =Xlookup(E2,$k$5:$K$11,$l5:$l11)

when in dragging down to fill in formula it is changing the $l5 to the next row $l6, etc.  It is not keeping the formula in tack.  Why is this happening?

[#2 · Accepted solution]

@klane8870 Then you should also put a $ sign in front of the 5, and probably also before 11.

[#3]

Oh my, I missed that, thank you very much!