FIND Function

Options
MarkTurkenburg_*8288
MarkTurkenburg_*8288
in Modeling

Hi Team,

 

I'm using the FIND function for the 1st time & it not working as I expected. 

 

It seems like a basic Function so I must be missing something easy but I would assume that below the value returned in the FIND line item would be 1 as it would find ANZ?

 

IMG1.PNG

 

Thanks

 

 

Tagged:

Best Answer

Answers

  • MarkTurkenburg_*8288
    MarkTurkenburg_*8288
    Options

     

     

    Hi @Harsha 

     

    Anapedia states the syntax is (cell containing text, text to find, starting point) which is what I did. 

     

    Is Anapedia incorrect?

     

    Thanks

     

     

    IMG1.PNG

     

  • MarkTurkenburg_*8288
    MarkTurkenburg_*8288
    Options

    My bad I was reading the instructions incorrectly

     

    It was just that simple!

     

    Thanks

     

     

  • sobaid
    sobaid
    Options

    Never Mind, Its confusing for me too, when I used it for first time!

Categories