I have multiple column that I want to apply vlookup to. Is it possible to
automatically increase the no. E.g
=Vlookup(c5,B:J,2,false), pick second row
=Vlookup(c5,B:J,3,false), pick third row
= lookup(c5,B:J,4,false), pick fourth row
=Vlookup(c5,B:J,5,false), pick fifth row
can I while dragging the filler automatically increase the 2,3,4,5 e.tc
across multiple cell without manually changing them.

All help totally appreciated. Thanks