Copy Cell Data from One Sheet to Another Based on Matching Values

Hi,

I have two sheets that I am working with. One sheet has a URL that I want to copy over to the other sheet. Both sheets have an identifier column titled "Org Unit ID". I have trying to write a formula that checks both sheets for a matching Org Unit ID and then copies the URL from sheet 1 (titled "Concourse_URL List") into sheet 2 (titled "Tool Usage Data") for the row where the Org Unit IDs match.

=IF(ISERROR(MATCH([Org Unit Code]@row, {Concourse_URL List Range 1}, 0)), "N", {Concourse_URL List [URL]@row})

Instead of returning "true,false" or "y/n", etc. I just want to return the data that is in the column titled URL located in the Concourse_URL List sheet on the row that has the matching Org Unit ID value.

Find more posts tagged with

IF(

Accepted answers

rrenee

I think based on your goals, you should use an INDEX(MATCH()) formula:

=IFERROR(INDEX({Concourse_URL List}, MATCH([Org Unit Code]@row, {Org Unit ID},0)),"")

This will return only the URLs and leave the cell blank if no URL is found.

{Concourse_URL List} = URL/info you want to pull into the new sheet
[Org Unit Code]@row = ID row for matching in the current sheet
{Org Unit ID} = ID column from the old sheet used to match the rows to

Cheers!

All comments

rrenee

I think based on your goals, you should use an INDEX(MATCH()) formula:

=IFERROR(INDEX({Concourse_URL List}, MATCH([Org Unit Code]@row, {Org Unit ID},0)),"")

This will return only the URLs and leave the cell blank if no URL is found.

{Concourse_URL List} = URL/info you want to pull into the new sheet
[Org Unit Code]@row = ID row for matching in the current sheet
{Org Unit ID} = ID column from the old sheet used to match the rows to

Cheers!

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.