Formula if Column E in Sheet 1 equals Column M in sheet 2, = Colum
 

Hello there,
I have following formula in Column K
=IF(E:E=sheet4!M:M,sheet4!Q:Q,"NO PRICE"), seems to work for some but since
Sheet 1 contains less records than sheet 2 then those that match don't pick
up price. So is there a way to pick all those that match in Sheet 1 Column E
to those that match in Sheet 2 column M?

Appreciate any help I can get.

Thanks,
J