| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare sheet 1 column A numbers with sheet 2 column A number | Excel Worksheet Functions | |||
| is there any formula that put the sheet name in any column or row | Excel Discussion (Misc queries) | |||
| How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
| How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
| How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
Hybrid Mode
