Hello
I am looking to use VLOOKUP to return certain column data out of an array.
Outside of a table this is what I have been using:
=VLOOKUP($B2,Sheet2!($A$8:$H$48,Column(B8),FALSE) and then dragged the formula across and down the page. This is fine, as the lookup locks to B.
However, when in a table with named ranges, I cannot drag the formula across as the initial reference keep changing as I drag across.
=VLOOKUP([@sampleid],[Book1]Sheet1!$A$8:$H$48,COLUMN(B8),FALSE)
The initial [@sampleid] needs to be locked, I assumed with $ but nowhere i put it allows the formula to function...
how do I lock this reference in a table?
Solved by S. Y. in 18 mins