If Function between different sheets

I'm trying to get an if function or something similar to work here. I have two different sheets and I'm trying to match an ID number. If the ID number appears on both sheets, I want the cell value to return with "Yes" and if not, "No". For example, this is the formula I currently have:

=IF([ID Number]1 = {First Year Experience 19-20 Range 1}, "Yes", "No")

Any help would be appreciated.

Thanks.

Find more posts tagged with

Accepted answers

Paul Newcome

Try something like this...

=IF(CONTAINS([ID Number]1, {Other Sheet ID Column}), "Yes", "No")

All comments

Paul Newcome

Try something like this...

=IF(CONTAINS([ID Number]1, {Other Sheet ID Column}), "Yes", "No")

Ryan Cornelius

Thanks, that worked great!

Paul Newcome

Happy to help! 👍️

Mily Oti

I'm trying to do something similar but I continue to get an error message. I have two sheets. In one, employees enter the time they spend on each task. This gets totaled to the column [Total Minutes]. On the second sheet I want to only show date and total minutes. I have no problem doing only one row but when I try to reference a complete column I get the error. This is my formula for one row only:

=IF({Translator Productivity Tool Range 1} = "LZ", {Translator Productivity Tool Range 2})

where range 1 is the employee and range 2 are the total minutes. This works fine but then when I try to reference the whole column it stops working.

Any help would be really appreciated.

Thanks,

Paul Newcome

@Mily Oti I'm not sure I follow.Are you trying to sum a total from another sheet, or...?

dharberts

If trying to use an IF statement using 2 sheets to see if the cells equal same text value and bring back a Yes or No value...

=IF([Applies to Country]@row = {Cnty}, "Yes", "No")

#INVALID OPERATION

Paul Newcome

@dharberts When you are creating the cross sheet reference, are you selecting a single cell? Are you able to provide some screenshots with sample data for context?

dharberts

I want to see if the info (above) form the main sheet matches the info (below) form another sheet, and if the countries exist on both then bring back either a Yes or No

Paul Newcome

If all you need is a yes or no if the country exists on the other sheet, you should should be able to use:

=IF(COUNTIFS({Other Sheet Country Column}, @cell = [Country Column]@row)> 0, "Yes", "No")

dharberts

got it thank you!

Paul Newcome

Happy to help. 👍️

dharberts

got it thank you!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.