IF Function - Begins With

**shg** · 12-01-2016, 03:22 PM

Good job sorting it out.

**mintyfresh2020** · 03-16-2021, 11:20 AM

so I need to do something like if a3 starts with a then j3 has this output, or if a3 starts with x then j3has this output, I'm getting lost in the nesting

**FDibbins** · 03-17-2021, 01:56 AM

Originally Posted by mintyfresh2020

so I need to do something like if a3 starts with a then j3 has this output, or if a3 starts with x then j3has this output, I'm getting lost in the nesting

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

**Toolman954** · 06-04-2021, 12:51 PM

I am in need of an IF Function that will check the first three characters in Column B and Set a Text Value in Column A for that row

Example: If Cell B1 = P42ABC123N, Then cell A1 is set to "F32"

IF B1 Begins with P21, Set A1 to F21 or,
If B1 Begins with P24, Set A1 to F24 or,
If B1 Begins with P28, Set A1 to F28 or,
If B1 Begins with P12, Set A1 to F32 or,
If B1 Begins with P32, Set A1 to F32 or,
If B1 Begins with P42, Set A1 to F32 or,
If B1 Begins with P33, Set A1 to S33 or,
If B1 Begins with P46, Set A1 to S46