Maybe you don't want the column index to be a number. Maybe you're asking how
do you match text in a title (topmost) row (like matching the text in the title
(leftmost) column.

If that's the case, =index(match(),match()) may work for you:
http://contextures.com/xlFunctions03.html
(especially examples 2 and 3.)


Rohit wrote:

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

--

Dave Peterson