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 SI...
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)