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 this happening?
klane8870 Then you should also put a $ sign in front of the 5, and probably also before 11.
2 Replies
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!
