Welcome!

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

Find more posts tagged with

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Exporting Smartsheet formulas
From my research, I understand there isn't a way to keep formulas when exporting from Smartsheet into an Excel document. I have a total of 50 columns with formulas and would think there was a quicker way to grab the formulas. So far, I've appended a "!" which turns the formula into text which does export. However, I'm not…
Distinct values from multiple sheets
I currently have 14 sheets with the following columns: Batch # and Reviewer I use an Index Distinct formula to acquire the unique batch numbers from all 14 sheets and put them into 14 columns on the 'metrics' sheet. I then use another index distinct to get a list of all the unique batch numbers into one 'Unique Batch…
Min Collect Help - date returning zero value
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…