The formula on the cell D6 on the sheet Aroha v2 should return the intersection value (B) of C5 (A3:A15 on the Sheet Tables) and D5 (B2:G2 on the Sheet Tables) looking up the table on the range A2:G15 on the sheet Tables.
2nd argument E2 --> 2 Column position 4 (OK)
3rd argument A10 --> G Row Position 8 (OK)
The Intersection of these two should have been E10 which is B.
Why doesn’t it work?
Bookmarks