I have a table, 12 columns x 18 rows, and I can't figure out how to return a value from a single cell.
If I look up a value from the top row and another value from the left most column, I need to return the value in the intersecting cell.
Here's an image that hopefully explains it better:
I'm sure I managed this many years ago in Exel but just can't figure it in Numbers. (and probably couldn't in Exel now, if I'm honest)
Any help would be appreciated.
If I look up a value from the top row and another value from the left most column, I need to return the value in the intersecting cell.
Here's an image that hopefully explains it better:
I'm sure I managed this many years ago in Exel but just can't figure it in Numbers. (and probably couldn't in Exel now, if I'm honest)
Any help would be appreciated.