Index and Match Formula Help

[Lecurota]

Hello,

I'm trying to have a formula give me a result for two criteria. I've evaluated the formula, and there's clearly something wrong with my match (Both show as 0s, so something isn't matching up, not sure why though.. I'll attach the files if I need to, but for now at least, I want to make sure the formula is okay.

Please Login or Register  to view this content.

[oeldere]

You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

[Lecurota]

Attached are the formulas.

Formula is in D13

Result should be 00305822 (with or with out leading zeros)

[Jonmo1]

It's an array formula that requires special keystroke to enter it in the cell correctly.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

And I HIGHLY recommend NOT using entire column references like C:C. Restrict all those ranges to the actual used area of the sheet like C1:C100