I have a table that I am trying to find values from, and am using Index() & Match() together. All is well when the values are positive, but I get a #N/A if I look a negtative value.
Match type is 1, and table is sorted negative to positive (both rows and columns).
Here's the formula I am using:
INDEX(Table!$B$4:$T$54, MATCH('Hit Log FY 07'!C6+1, Table!$A$4:$A$54,1),
MATCH('Hit Log FY 07'!D6+250, Table!$B$3:$T$3,1))
The rows of the table range from -55 to 55, and the columns range from
-1000 to 10000.
TIA!
Bookmarks