Error #N/D in corresp function

the formula is giving me the result
# N / D when intend to returne the "C" value.

The problem is that the values in B7 and C7 are NOT 0036 and 0058
They're actually just 36 and 58, but the cells are formatted to include the leading 0's.

Try
=INDEX(Folha1!D4:D7,MATCH(D13+0&E13+0,Folha1!B4:B7&Folha1!C4:C7,0))

See attached and see if you can spot what I changed (it's not very subtle!)

also does not work. continues to give error

Originally Posted by Jonmo1

The problem is that the values in B7 and C7 are NOT 0036 and 0058
They're actually just 36 and 58, but the cells are formatted to include the leading 0's.

Try
=INDEX(Folha1!D4:D7,MATCH(D13+0&E13+0,Folha1!B4:B7&Folha1!C4:C7,0))

Originally Posted by Birnen

also does not work. continues to give error

Works for me. Could be that you have a different language version of Excel.
You need to use the equivelent function names for Index and Match.

If you open this, it should auto translate for you. (as yours did for me)
EFBirnen.xlsx