Forum Discussion

Copper Contributor

Oct 11, 2019

Solved

Excel - Index Match Formula

Hi Guys, I need help related to Index and Match formula, I am getting #N/A value from match getting the row number, I'm a beginner in writing this kind of formula so appreciate any help from the ...

spreadsheet.xlsx13 KB

Excel Index Match Formula

Formulas and Functions

SergeiBaklan
Oct 11, 2019
elsu186

I'd suggest

=INDEX('S-Box'!$B$2:$Q$17,HEX2DEC(LEFT(A2))+1,HEX2DEC(RIGHT(A2))+1)
spreadsheet.xlsx15 KB

SergeiBaklan

Diamond Contributor

Oct 11, 2019

elsu186

I'd suggest

=INDEX('S-Box'!$B$2:$Q$17,HEX2DEC(LEFT(A2))+1,HEX2DEC(RIGHT(A2))+1)

spreadsheet.xlsx15 KB

elsu186

Copper Contributor

Oct 11, 2019

Many thanks SergeiBaklan it works... Appreciate your help...

SergeiBaklan
Diamond Contributor
Oct 11, 2019
elsu186 , you are welcome, glad to help