Formula to Autofill column

[VidOs]

Hi,

I'm searching for a formula to autofill a certain column based on matches between other columns, example:

I want column M to be autofilled with values from column C in the case that column J:L matches with D:F.

I've attached a file to make the illustration clearer!

[JeteMc]

Paste the following array entered formula* into M6:

Please Login or Register  to view this content.

*1) Press the F2 key,
2) Simultaneously press Ctrl, Shift and Enter
3) Double click the fill handle to copy down.
Let us know if you have any questions.