Exact word equalling

[metalkitty]

Below is the formula I am using. So basically if B3 = C2, then place that word in this cell. What I need help with is, if C2 = ac and the word pack is in B3 than this will = ac. How can I make the formula only = the exact word ac?? Hope that makes sense

=IF(ISERROR(FIND(C$2,$B3)),"",C$2)

 

[Richard Schollar]

Hi

=IF(EXACT(C2,B3),C2,"")

 

[metalkitty]

Exact word.

Oops, I left out a part of my problem.

Let say that cells = the below

B3 = We had no ac
B4 = We had to unpack

This formula will tell me that both B3 and B4 contain ac
=IF(ISERROR(FIND(C$2,$B3)),"",C$2)

This will only show me when ac is alone
=IF(EXACT(C2,B3),C2,"")

Anyone know how I can make the formula show when the exact word ac is present in the sentence?

Hope I explained it better
[/img][/code]

 

[Scott Huish]

So are you trying to return the result in C2 only if B3=B4 and both contain the complete word ac (the value from C2)?

 

[metalkitty]

Book5
	A	B	C	D	E
1	currentlyhavefromusingthisformula =IF(ISERROR(FIND(C$2,$B3)),"",C$2)
2			ac	air
3		wehadnoac	ac
4		wehavetounpack	ac
5		wesatinachair		air
6		Iloveair		air
7
8	Iwouldlikemyformulatomakeitlooklikebelow
9			ac	air
10		wehadnoac	ac
11		wehavetounpack
12		wesatinachair
13		Iloveair		air
Sheet1

 

[metalkitty]

So I would like "ac" to fill C3 but not C4. I would like to have the above bottom chart. Only sentences that contact the whole word ac not in a word. Hope this clears things up

 

[Scott Huish]

=IF(ISNUMBER(FIND(" "&C$2 & " "," "&B10&" ")),C$2,"")

 

[metalkitty]

Thank you so much!!!! would have never gotten it on my own