Forum Discussion
Finding cell name given two inputs
Dear Sir,
I have spread sheet like below.
| Frquency | SIL | ||||
| 5 | SIL3 | SIL4 | SILH | SILH | SILH |
| 4 | SIL2 | SIL3 | SIL4 | SILH | SILH |
| 3 | SIL1 | SIL2 | SIL3 | SIL4 | SILH |
| 2 | SIL0 | SIL1 | SIL2 | SIL3 | SIL4 |
| 1 | SIL0 | SIL0 | SIL1 | SIL2 | SIL3 |
| Consequence | 1 | 2 | 3 | 4 | 5 |
| Frequency | 1 | ||||
| Consequence | 3 | ||||
| SIL | XXX | ||||
I want to write formula in cell as shown as XXX, the formula should give me the result as SIL1, if i change Frequency and Consequency like say 2, 4 respetively then i should get SIL3.
Please let me know what formulae or function i should use, roughly i know it is like INDEX and Match, i tried but INDEX take only column but my arry is in both column and rows like B2:E6.
Regards.
3 Replies
Here are few more options-
=INDEX(B2:F6, MATCH(B9,A2:A6,0),MATCH(B10,B7:F7,0)) =FILTER(FILTER(B2:F6,A2:A6=B9),B7:F7=B10) =XLOOKUP(B10,B7:F7,XLOOKUP(B9,A2:A6,B2:F6)) =CHOOSECOLS(CHOOSEROWS(B2:F6,XMATCH(B9,A2:A6)),B10)Thanking you very much HansVogelaar for the quick reply and solution.
Like this:
See the attached demo.
