Red over White
Board Regular
- Joined
- Jul 16, 2011
- Messages
- 123
- Office Version
- 365
- Platform
- MacOS
Having looked on Mr Excel I have found the formula
=MIN(ISNUMBER(SEARCH(R2,'All results'!A3170:A3179)),ROW('All results'!A3170:A3179))
which goes some way to solving my issue as it comes up with 3170. R2 = “2023-24”
What I am try to do is hone in on cell B3172, the first cell where Column A is equal to Cell R2 and then the first cell in Column B which has an entry (can be anything).
Any suggestions?
=MIN(ISNUMBER(SEARCH(R2,'All results'!A3170:A3179)),ROW('All results'!A3170:A3179))
which goes some way to solving my issue as it comes up with 3170. R2 = “2023-24”
Row | Column A | Column B |
3169 | 2022-23 | |
3170 | 2023-24 | |
3171 | 2023-24 | |
3172 | 2023-24 | National |
3173 | 2023-24 | National |
What I am try to do is hone in on cell B3172, the first cell where Column A is equal to Cell R2 and then the first cell in Column B which has an entry (can be anything).
Any suggestions?