Forum Discussion

Pam Laidler's avatar
Pam Laidler
Copper Contributor
Sep 28, 2018

HELP WITH IF STATEMENT

In cell C13 I have a person's name i.e. Fred Block

In another cell, CALCULATOR!B9, I have people's names plus other words i.e Fred Block Executive or Joe Brown Senior

I want to say if the name/text in C13 can be found in cell CALCULATOR!B9, then return the value found in other cell CALCULATOR!D9

Can anyone help please?

thanks

Pam

 

excel
Formulas and Functions

20 Replies

    • Pam Laidler's avatar
      Pam Laidler
      Copper Contributor
      Sep 28, 2018

      Hi Lorenzo - unfortunately no that didn't work.  C13 won't equal the other cell, just have part of the text.

      P

      • Lorenzo Kim's avatar
        Lorenzo Kim
        Bronze Contributor
        Sep 28, 2018

        how about this?
        =IF(C13=MID(CALCULATOR!B9,SEARCH(C13,CALCULATOR!B9),LEN(C13)),CALCULATOR!D9,"")
        HTH

Resources