Matching 3 criteria

[cyee]

Dear Pro,

May I know is there anything wrong with my formula below? Its give me #NA.

I would like to match criteria at B6, B1 & B2. All must match.

Please Login or Register  to view this content.

Thanks in advance.

[JohnTopley]

Guesing ..

=IFERROR(INDEX('mth contr'!$E$1:$E$3,MATCH(B6&B1&B2,'mth contr'!$A$1:$A$30&'mth contr'!$B$1:$B$30&'mth contr'!$C$1:$C$30,0)),"")

Enter with Ctrl+Shift+Enter

It would help if you post a sample workbook: see yellow banner at top of page.

[wk9128]

Guesing , Array formula

[cyee]

Thank you very much for the reply. But both formula doesn't work.
I attached a sample here. Hope it help.

[wk9128]

Cell B16 array formula

[JohnTopley]

@cyee

PLEASE do not used merged cells: they are a nightmare!

Formula works with unmerged cells.

[cyee]

That's fantastic!!

Thank you very much!!

[wk9128]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'.