If Statement

S

Secret Squirrel

How do I write an "IF" statement to find a cell that has the letter "G" in it.

Example:

HW-G12345

The letter "G" won't always be in the exact spot in each cell.

Any help would be greatly appreciated.
 
A

AKphidelt

Try this

=IF(ISERROR(FIND("G",A1,1)),"no","yes")

Change A1 to whatever cell the value is that you want to find G in.
 
R

Ragdyer

What exactly do you mean by find?
Do you want the cell address?
Do you want data returned from an adjoining column on the same row?

And where exactly are you searching?
A column?
An array/
The entire sheet?

And will there be duplicates, where you'll want more then a single return?

How about more info.
 
S

Secret Squirrel

Perfect! Thanks!

AKphidelt said:
Try this

=IF(ISERROR(FIND("G",A1,1)),"no","yes")

Change A1 to whatever cell the value is that you want to find G in.
Click to expand...
 
Top