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

[K.S.Warrier]

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.

 

[Arvi Laanemets]

Hi

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

 

[Govind]

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