#NOMATCH multiple function

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

#NOMATCH multiple function

Hello,

I actually have some #NOMATCH problem, that I can't explain because it work different cells of my sheet that have same parameters.

My formula is :

=IF(ISBOOLEAN(VLOOKUP([N° CONTAINER]1; {LDS Container Dashboard plage 2}; 21)) = 1; 1; 0)

When I check column where I take datas, it should be checked as well

If someone can help me to understand, will be really appreciated ^^

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Laurent,

    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some more screenshots of the other sheets and ranges? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    I hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    What is in the [N° CONTAINER] column, and what is in the range in the cross sheet reference?

  • Hello Everyone,


    Sorry for delay ^^

    I had so many things to do that were more urgents :)

    here is the full sheet screenshot that I'm working on


    And here is the sheet screenshot that I'm using as database

    I tried to change formula, but it doesn't work either ^^

    Thank you for your help :)

  • Hi Laurent,

    I still continue the thread in english, even I'm a french native speaker.

    My suggest is to add a last argument to the VLOOKUP function : VLOOKUP(... ; ... ; 21; FALSE).

    From my experience, it is a regular way to use thie function, also in other sheets tools, like MS Excel or Google Sheets.

    I hope it will help.

    Have a nice day !

    Pierre

  • Hi Pierre,

    You won ^^

    The correct formula is :

    =IF(VLOOKUP([N° CONTAINER]1; {LDS Container Dashboard plage 2}; 21; False) = 1; 1; 0)


    Thank you all for your help 😄

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Glad you were able to get it working. 👍️

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Laurent DESSOLLES

    Glad you got it working!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.