how can i use vlookup to return value using the col_index_num to be a cell
refence instead of column number.

=vlookup(...............,2,false) to be

=vlookup(................a1,false)

cheers