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!!
Bookmarks