display specific data from a group of cells

[osaben]

I have data is three cells (M15, M27 & M39). They may have various text in them, but only one cell will be either "Overtime" or "PointinTime".

In cell M44 I would like to display the data from whatever cell contains the either the word Overtime or PointInTime.

I am unsure how to do this. I thought it might be "match", but that doesn't seem to be it.

Any suggestions?

Thanks!

 

[JoeMo]

Assuming the keywords are not part of a larger string:

=IF(OR(M15= "Overtime",M15="PointInTime"),M15,IF(OR(M27= "Overtime",M27="PointInTime"),M27,IF(OR(M39= "Overtime",M39="PointInTime"),M39,"")))

 

[Twollaston]

I have data is three cells (M15, M27 & M39). They may have various text in them, but only one cell will be either "Overtime" or "PointinTime".

In cell M44 I would like to display the data from whatever cell contains the either the word Overtime or PointInTime.

I am unsure how to do this. I thought it might be "match", but that doesn't seem to be it.

Any suggestions?

Thanks!

this is a fun formula
=IF(OR(IFERROR(SEARCH("PointinTime",M15)>0,0),IFERROR(SEARCH("Overtime",M15)>0,0)),M15,IF(OR(IFERROR(SEARCH("PointinTime",M27)>0,0),IFERROR(SEARCH("Overtime",M27)>0,0)),M27,IF(OR(IFERROR(SEARCH("PointinTime",M39)>0,0),IFERROR(SEARCH("Overtime",M39)>0,0)),M39,0)))

 

[osaben]

Thank you Joe Moe!

This what just what was needed!