=vlookup(lookupvalue,lookuprange,column(),0)


"Pawan" wrote in message
...
Hi,

I have a sheet with 52 columns and 250 rows. First column contains
student's
name. I am using VLOOKUP function so that when I enter name of student,
all
his data will be displayed in that row. For that I have to write VLOOKUP
formula for each cell in that row. But then I have to write parameter
"col_index_num" manually in each cell of that row. Is there any way so
that
when I write formula for one cell, and after dragging it over the entire
row,
"col_index_num" will change correspondingly for all cells in that row?