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...
excel
Formulas and Functions
Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Sep 28, 2018
try this:
=IF(C13=CALCULATOR!B9,CALCULATOR!D9,"")
HTH
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
    • Pam Laidler's avatar
      Pam Laidler
      Copper Contributor
      Sep 28, 2018

      Hi Lorenzo - I get #VALUE for this   (never come across MID and LEN - I've have to look those up)

       

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

        pls see attached file.

        hope you can work something out of it

        thanks..

         

Resources