Vlookup Formula help

I always struggle with formulas....this time VLOOKUP. After creating the formula the cell says #UNPARSEABLE. I'm sure it's something simple, but I always fail in troubleshooting formulas.

I am looking up the username in another sheet and retrieving the Created Date data.

Here are my screenshots. Hope you can tell what I am doing as I had to blur out some things.

Lookup sheet

Field selection from cross reference lookup

If I change the first argument in the VLOOKUP to VLOOKUP(Username@row), .... I get the #INCORRECT ARGUMENT error.

Thanks!

Pam

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @Pamb10

I hope you're well and safe!

Try something like this.

=VLOOKUP(Username@row, {??? Onboarding List for Lookup Username},6,false)

Did that work/help?

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!

Pamb10

Hi Andree,

Thank you for your assistance. When I make those changes I get #INCORRECT ARGUMENT.

Andrée Starå

@Pamb10

Happy to help!

Strange!

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Pamb10

Much appreciated. Had to modify the data a bit. I shared it with you.

Pamb10

Hi Andree,

Just wanted to make sure you were able to access the shared files.

Pamb10

I just realized partially what I am doing wrong, although I am not really sure why it still didn't work. Let me explain...

For the second parameter of the VLOOKUP i was choosing a single column (username). I assume since it did not include the column containing the data I wanted to return, it barfed.

I have now corrected the second parameter of the VLOOKUP to include all columns of the lookup table. However, now I get a #NO MATCH error. But there should be a match, I see the username value I am testing with, its just not finding it....

This is the formula I am now working with:

=VLOOKUP(Username@row, {Onboarding List Range 1}, 2, 1)

I was wondering if maybe there are spaces before or after the content in the username field, but when I click on it to check, i do not see any.

Pamb10

Hi Andree,

Were you able to get it working or see what is wrong?

Thanks

Pam

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.