Excel-value in a range of cells for two cross references
 

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.

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.

Hi,

Try

=INDEX($A$1:$M$13,MATCH(A3,$A$1:$A$13,0),MATCH(C1, $A$1:$M$1,0))

Assuming A3 is the vale you need from A2:A13 and C1 is the value you
want from B1:M1.Change the formula according to your requirement.

Regards

Govind.

Assuming A3 is the

K.S.Warrier wrote:
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.