I have a range of 10 contiguous cells in a single column. I want to enter the same VLOOKUP formula in each of the cells but return the relevant value from a lookup table made up of an index column and 10 value columns.
So, for example, =VLOOKUP(B7,LookupTable,2,1) will return the value in the 2nd column of the lookup table. And =VLOOKUP(B7,LookupTable,3,1) will return the value in the 3rd column of the lookup table.
What common formula can I use without having to change the column number for each cell ?