Dollar sign/ Vlookup

Copper Contributor

I'm using a Vlookup( Lopslag), but need to drag it to the right, but this makes the Vlookup change the Lookup_value one to right as well, can i use the $ somehow here?

Mimo_2020_0-1598881552535.png

1 Reply

@Mimo_2020 

Please fix the reference on the column like

[@[Maler Nr.]:[Maler Nr.]]