Forum Discussion
Solved
Adding a column to an array reference
I have a table, say Things, with two columns. I use a reference to this table elsewhere in the workbook, =Things, and the table spills into the cells there in two columns - an exact reference to ...
Either refer to the original column or use INDEX() to get the column data.
=VLOOKUP(Things[Column1],lookup_table,2,FALSE) =VLOOKUP(INDEX(F2#,0,1),lookup_table,2,FALSE)
Either refer to the original column or use INDEX() to get the column data.
=VLOOKUP(Things[Column1],lookup_table,2,FALSE)
=VLOOKUP(INDEX(F2#,0,1),lookup_table,2,FALSE)- Thank you very much.
