nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

How to Cross Reference Data from Another Sheet

pkburns

I'm trying to link data from a column in one sheet to the similar column in another sheet. What is the best way to do that? I can't seem to get the VLOOKUP formula to work properly. Thank you.

Find more posts tagged with

Education

Formulas

Comments

Robin Thomas

Have you worked with DataMesh? That's how I link large amounts of data.

Paul Newcome

Are you able to provide more details? Are you using specific criteria to pull the data over or is it just a simple transfer?

Are you able to provide screenshots with sensitive/confidential data removed, blocked, or replaced with "dummy data"?

Andrée Starå

Hi,

How much information is it? It might work with cell-linking.

I agree with Paul. More information would help.

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sign in to join the conversation!

Quick Links

Trending discussions

Month End Checklist Notifications
Hi all, I'm building out a month-end checklist for a department and they want to be reminded on Day 1 of every month to start their tasks and on Day 10 to complete their tasks. I was able to create a simple workflow that on Day 1 and Day 10 of every month, it sends them a reminder, however, they have asked if day 1 or 10…
#DATE EXPECTED
I have a column that displays the date from a reference in another sheet. However there is a different column on that the source sheet where a date can be entered and it should display that date if entered. I tried to error trap for blanks but I am still getting #DATE EXPECTED. Here is the formula for context.…
INDEX/COLLECT/CONTAINS
I need to pull the Form ID (and other columns) from Sheet B into Sheet A. These conditions all need to be met: Departure Date ⇒ Date Field 1 Departure Date =< Date Field 2 Destination (Sheet B) contains City (Sheet A) Name (Sheet B) contains Last Name (Sheet A) This is the current formula I have: =INDEX(COLLECT({Form ID},…