This seems to work for me, where the lookup value is in A2 and the lookup
column is in A1. Change A1 and it selects a different column to return.

=VLOOKUP(A2,D1:G3,A1,0)

In certain cases, which escapes me now, you may have to use INDIRECT(A1) to
make it work.

HTH
Regards,
Howard

"Rohit" wrote in message
...
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