Forum Discussion
Solved
VLookup Formula not copying down correctly
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...
klane8870 Then you should also put a $ sign in front of the 5, and probably also before 11.
klane8870 Then you should also put a $ sign in front of the 5, and probably also before 11.
Oh my, I missed that, thank you very much!