Excel IF Statement Query

Question

Trying to get my head around an IF statement (which generally speaking I'm normaly OK at!)

The example would be Sheet name 201401_ABC123_XYZ

I bascically want to say if the text after the first _ reads ABC123 then return the value 123 else return 456.

Any help would be appreciated

thanks Jim

Sorry, but what exactly is the conditon in plain words? Do you want to evaluate the sheet name? Can you explain the context? An IF statement normally looks at cells, not sheet names. Or is what you call a "sheet name" a text in a cell? What are you trying to accomplish? — teylyn
– teylyn, Commented Oct 8, 2014 at 10:24

Nilesh Thakkar · Accepted Answer · 2014-10-08 10:27:27Z

1

Consider Cell A1 has your text i.e. "201401_ABC123_XYZ"

=IF(MID(A1,FIND("_",A1)+1,6)="ABC123","123","456")

Here 6 is length of your string you want to search for i.e. "ABC123" "ABC123" - is your string you want to search for and 123 and 456 is string you want to return as per your question.

Hope this will help.

answered Oct 8, 2014 at 10:27

Nilesh Thakkar

1,4594 gold badges27 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel IF Statement Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related