For two-dimensional lookups see:


http://www.cpearson.com/excel/lookups.htm
--
Gary's Student


"Bob Phillips" wrote:

Try something like

=INDEX(A1:H20,MATCH(row_value,A1:A20,0),MATCH(heig ht_value,A1:H1,0))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"raraschek" wrote in message
...
hi.i ve got a data table where rows are width and columns are hight. how
do i
get data from the cell that matches ceartin column and row,? I use
vlookup,
or index, and IF. but IF can be used only 7 times, i need to use it 16
times.
thanx