Thread: Formula if Column E in Sheet 1 equals Column M in sheet 2, = Colum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Juan Juan is offline
external usenet poster
  
Posts: 70
Default 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


Reply With QuoteReply With Quote