Is there a way to drag the vlookup formuls over cells so that the index cell changes. i.e
vlookup(A3, data, 1) i want to drag the formula to the next cell using autofill so that it changes to: vlookup(A3, data, 2). If i try and autofill, it changes A3 to A4 rather than the 1 to a 2.
Thanks
vlookup(A3, data, 1) i want to drag the formula to the next cell using autofill so that it changes to: vlookup(A3, data, 2). If i try and autofill, it changes A3 to A4 rather than the 1 to a 2.
Thanks