Hi

=INDEX($B$2:$M$13,MATCH(Value1,$A$2:$A$13,0),MATCH (Value2,$B$1:$M$1,0))


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"K.S.Warrier" wrote in message
...
Sirs,
Is there an easy way to find a corresponding value from a range of
cells("m"rows &"n" columns) by looking to one value in a cell from a row &
another value in another cell from a column.
Example:
Soppose, cells b1:m1 contains 12 values; cells a2:a13 contains 12 values.I
want to find a value from b2:m13(144 cells) corresponding to a value from
b1:m1 & another value from a2:a13.I have found out a round about method
..Is
there any short formula using ' if,lookup,....' for this.
Thanks & regards.