Hello,

I have created a matrix which has three columns: "north", "south" and
"west". The rows below the columns are sequenced by their respective
row number and below each column has different values.

My questions is: If I create three cells- "Direction","Row" and
"Value", how can I populate the intersecting value in "Value" by when I
input in "Direction" and "Row"??

Example: Direction = north; Row = 2; Value = [would this be a DGET or
IF function?]

Thanks in advance for your responses!!


--
tommyf
------------------------------------------------------------------------
tommyf's Profile: http://www.excelforum.com/member.php...o&userid=28511
View this thread: http://www.excelforum.com/showthread...hreadid=481017