Trying to Work with the VLOOKUP Function but hitting a wall

I'm attempting to access a separate sheet with some contact details for various clients.

On my CLIENT SHEET I have 8 columns:

Licensee, Billing Company, Contact, Contact Email, Street, City, State, Zip

On my PROJECT SHEET I have various other project details, but one column is also named "licensee".

In the Licensee column, I can select from a number of values that directly match values in the "Licensee" column on the CLIENT SHEET

What I would like is for the corresponding contact, email, city, state, zip, etc... cells on my PROJECT SHEET to automatically fill in based on the Licensee entered, and the matching data from the CLIENT SHEET.

I'd show you some code, but I really don't have much to share. VLOOKUP confuses me.

Any help greatly appreciated

Find more posts tagged with

Sheets

Formulas

functionality

Project Management

Cell linking

Accepted answers

Neil Watson

Many of the more experienced users (i.e. not me) on this forum recommend the use of INDEX/MATCH in place of VLOOKUP.

Here is a post that explains the use: https://community.smartsheet.com/discussion/36341/index-and-match

Once worked out, it's a winner!

All comments

Neil Watson

Many of the more experienced users (i.e. not me) on this forum recommend the use of INDEX/MATCH in place of VLOOKUP.

Here is a post that explains the use: https://community.smartsheet.com/discussion/36341/index-and-match

Once worked out, it's a winner!

Ron Cassel Jr.

Incredible. This worked perfectly! Thank you so much.

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.