[Solved] VLOOKUP search array increments when copying formula

[Urbanfarmervb]

Hi
I am Unable to keep my search array in Vlookup constant in CALC

It Keeps incrementing as i drag to the cells below

Looking for support in this pls

Thanks

[Hagar Delest]

Hi and welcome to the forum!

I guess you need the $ when defining the range, see section 8 in: [Tutorial] Ten concepts that every Calc user should know.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the 🖉 button if your issue has been fixed.