If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
If Statement
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. |
#2
|
|||
|
|||
If Statement
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. "Secret Squirrel" wrote: 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. |
#3
|
|||
|
|||
If Statement
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. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Secret Squirrel" wrote in message news 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. |
#4
|
|||
|
|||
If Statement
Perfect! Thanks!
"AKphidelt" wrote: 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. "Secret Squirrel" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|