Hello,
I was hoping someone could help me with a problem I'm having in Excel. I have a 25x25 table e.g.
1 2 3 4 5 ..... 25
1 1 1 1 1 ..... 1
2 2 2 2 2 ..... 2
3 3 3 3 3 ..... 3
4 4 4 4 4 ..... 4
5 5 5 5 5 ..... 5
. . . . .
. . . . .
. . . . .
25 25 25 25 25 ..... 25
I'm trying to find a way to locate the cell where if the top row (red) equals e.g. 2 and the value in the column under this heading equals e.g. 4, then the formula tells me that this number exists in cell B5
Thanks
Bookmarks