VLOOKUP Formula

Hi Smartsheet community!

This may seem like a simple question but I cannot figure out this formula for the life of me.

I am trying to do a basic VLOOKUP formula. On sheet #1 I will have a column that lists employee alias's and a column that will VLOOOKUP that same alias's level from sheet #2.

On sheet #2 it will be a list of alias's and their matching level.

Sheet #1: (raw data no formula)

Sheet #2: (VLOOKUP Sheet)

I am needing the VLOOKUP formula to pull the level listed on sheet #1 and match it to the alias on sheet #2.

I keep getting error messages back and I cannot figure out what I am doing wrong.

Thanks in advance!

Find more posts tagged with

Sheets

Formulas

functionality

Automations

Accepted answers

All comments

Andrée Starå

Hi @BCK Team

I hope you're well and safe!

Can you paste the formula you're working with here?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Bassam Khalil

Hi @BCK Team

Hope you are fine, please check the following formula

=VLOOKUP(Alias@row, {Sheet#1 Level}, 2)

i suppose the column number in the searching table in sheet#1 for levell is 2

BCK Team

Hi @Andrée Starå

I hope you are well, safe and happy too!

I re-read my initial post and realized I explained my situation backwards. My apologies.

This is what I am needing.

Sheet #1 will contain a list of an employee alias's, sometimes the alias will be listed multiple times. In the column "Level (Formula)" on sheet #1, I am needing the VLOOKUP formula to pull the level that matches this alias from Sheet #2.

Sheet #1:

Sheet #2 will hold a list of all employee alias's and their matching level. This is where the formula (in sheet #1) will be pulling from.

Sheet #2:

I have tried a variation of formulas:

=VLOOKUP(Alias@row, {Sheet #2 Range 1} + {Sheet #2 range 2}, 2)

=VLOOKUP(Alias@row, {Sheet #2 Range 1}:{Sheet #2 range 2}, 2)

I am not sure how to fix my formula.

Thanks again for the help :)

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.