#NOMATCH multiple function

Laurent DESSOLLES

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 ^^

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, andree@getdone.se)

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

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

Laurent DESSOLLES

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 :)

Pierre Galiegue

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

Laurent DESSOLLES

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 Newcome

Glad you were able to get it working. 👍️

Andrée Starå

@Laurent DESSOLLES

Glad you got it working!