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
Pam Laidler's avatar
Pam Laidler
Copper Contributor
Sep 28, 2018

Hi Lorenzo - I get not found, but in some cases I should actually get the $amount so still not quite right. :(

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Sep 30, 2018
    glad to hear that...
    thanks
  • Pam Laidler's avatar
    Pam Laidler
    Copper Contributor
    Sep 30, 2018

    Hi Lorenzo

     

    I ended up doing the following and it seems to work

    =IFERROR(IF(FIND($C$13,CALCULATOR!B10)>0,CALCULATOR!I10),0)

    Thanks

    Pam

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

    Thanks for your time Lorenzo

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Sep 28, 2018
    maybe the criteria is not set right..... maybe some other time
    good luck..

Resources