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

J

Juan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to figure out IF formula 4
Excel formula for counting nr records with data and related empty fields 3
Code to copy column in sheet 1 to column in sheet 2 based on matched criteria 0
Assembling large "array" 3
A Huge Conditional Format Challenge.... 2
Formula re value in column C or D, calculations made on either in column E? 8
Column Match function to replace 0
Macro for compare between 2 workbooks and copy adjacent cells 1

Top