Index-Match formula is not working ...whats missing ?

**raad** · 11-16-2012, 01:33 PM

Hello Everyone :

I am knew to this forum and I appreciate if some one can help

I Don't know whats wrong with my Index match formula ? I am trying to match the shippers names with the receiver name using the common four digit numbers but its not working

Please see the attached file .....check Excel formula.xlsx

**jeversf** · 11-16-2012, 01:40 PM

index&match2.xlsx

Try this instead Raad (see attached),

cell F3 =INDEX($G$3:$G$20,MATCH(B3&C3&D3&E3,$H$3:$H$20&$I$3:$I$20&$J$3:$J$20&$K$3:$K$20,0)) [hit cntl+shift+enter)

you pretty much had it right....but hit control + shift + enter to execute and copy down for cells f4:f18.

**Moo the Dog** · 11-16-2012, 01:41 PM

It works fine for me... you didn't actually type the { and } in did you? Those aren't manually typed in. You need to type the formula you have without the { and }, but instead of just hitting enter to apply the formula, you have to hit Ctrl + Shift + Enter to apply it as an array formula.

Hope this helps!

- Moo

* Edit - jeversf beat me to it

Also, as he demonstrated, your ranges need to use absolute references ($), otherwise you'll end up with a bunch of cells with #N/A in them.