Formula to match multiple cells in 2 sheets

sourabhg98,
your formula work too.

However, if you want to go with helper column I would suggest to use one one (on sheet2).

So your formula would be:

Formula:

=INDEX(Sheet2!M:M, MATCH(I2&","&J2&","&K2&","&L2,Sheet2!Q:Q,0))

Also, optionaly, it's better to use non-standard delimiters (that I didn't include in mine solution since it's unlikely to happend but it would be better).

So instead of , or . or space etc. use something like | ~ ^ etc.

Formula:

=INDEX(Sheet2!M:M, MATCH(I2&"^"&J2&"^"&K2&"^"&L2,Sheet2!Q:Q,0))