VLOOKUP Across Sheets

Hi,

Looking for some help from the SS gurus out there, VLOOKUPs across sheets this time. This is the syntax I have at the moment.

VLOOKUP({Data Entry - Stage 3 Range 1}[Variant SKU]@row, [Variant SKU]1:Tags2, 1, false)

Below are the source columns for the lookup, within our Data Entry - Stage 3 sheet.

We would use Data Mesh, but there is already quite a complex formula within this column. The full column formula is below for reference;

=[Invoice number]@row + ", " + Supplier@row + ", " + [Internal Identifier]@row + IF([Margin Scheme]@row = 1, ",Margin") + ", " + Childrens@row

Plus the additional vlookup.

Thanks in advance,

Simon

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @Simon Potton

I hope you're well and safe!

At a glance, the ranges don't look correct.

I'd be happy to take a quick look.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Simon Potton

Hi Andree,

Thanks for the message, I have emailed across some more information, look forward to hearing back from you!

Thanks again,

Simon

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.