#N/A on index match multiple criteria

Hard to say what the problem might be without seeing some sample data.

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

First MATCH is incorrect, should be: MATCH(TRUE,...,0) or MATCH(1,--(B2=...),0)
Second MATCH looks correct. It is easier if you can post a dummy sample.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

There is no formula in the attachment.

Please explain the numbers highlighted in yellow.

I tested with 6D in B2, "AAA111" in column F and "XYZ1111" in column G with 2 option: INDEX(Array formula with Ctrl-shift-enter: returns 1st instance if there are more than 1 case) and LOOKUP( normal formula return last instance if there are more than 1 case)
=INDEX($N$2:$N$23,MATCH(1,($C$2:$C$23=$B$2)*($F$2:$F$23="AAA111")*($G$2:$G$23="XYZ1111"),0))
=LOOKUP(2,1/($C$2:$C$23=$B$2)/($F$2:$F$23="AAA111")/($G$2:$G$23="XYZ1111"),$N$2:$N$23)
It seems OK. If it does not work, try to put your formula in spreadsheet.

Ok I've got it working after double checking my code to yours and had some syntax errors that I didn't notice in my original spreadsheet... -.-


Thanks for the assistance.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.