Exact word

**WCE_123** · 10-27-2011, 10:10 AM

Hi,

I would like Double Pg Input only to show in cell if it matches exactly in A2

=IF(ISNUMBER(FIND("Double 1",A2)),"Double Pg input"&" "&D2,"")

Cheers

Colin

**TMS** · 10-27-2011, 10:16 AM

What do you mean by "matches exactly"? The only content in the cell? Other words but around the search item? Format the same? Number the same?

Post some examples of what constitutes an exact match and what doesn't.

Regards

**WCE_123** · 10-27-2011, 10:26 AM

Hi,

A2 must have the word "Double 1" typed in the cell - then "Double Pg Input" will show,
if the word " Double 1a" is typed in then the a blank will show.

=IF(ISNUMBER(FIND("Double 1",A2)),"Double Pg input"&" "&D2,"")

Hope this helps,

Cheers

Colin

**daddylonglegs** · 10-27-2011, 10:32 AM

FIND just looks for Double 1 anywhere in the cell, if the cell should be exactly "Double 1" with no other characters then just use a direct comparison, i.e.

=IF(A2="Double 1","Double Pg input "&D2,"")

**TMS** · 10-27-2011, 11:16 AM

@DDL: picking up the tricky ones now, huh!?

**daddylonglegs** · 10-27-2011, 01:22 PM

I think it was Descartes who said "there are no easy questions, just some that are less hard" (or was that Kenny Dalglish?)

**TMS** · 10-27-2011, 01:27 PM

@DDL: there again, a question is only hard if you don't know the answer, easy if you do, and "puzzling" if you think you should know the answer (and possibly do) but can't for the life of you think what it is.

Regards