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.