Help with vlookup

Hi team - I have a sheet that has a list of question numbers, in one column, and actual question text in the other column:

I have another sheet where I want to look for the question number then pull in the RFP Evaluation Questionnaire text from the first sheet that corresponds with the number into the Question # column on this sheet:

I've tried the following formula and continue to get a "no match" error: =VLOOKUP([Question #]@row, {RFP Question & Number}, 2, false) NOTE: RFP Question & Number refer to the column range from the first sheet (image above)

I'm not worried about the "General question" text returning a RFP Evaluation Questionnaire match because I know it won't.

What am I doing wrong?

Find more posts tagged with

Accepted answers

Paul Newcome

Am I correct in assuming the Question # Column in the first sheet is the Primary Column? If so it looks like you may be comparing text values to numerical values.

Try wrapping the formula in the second sheet's Question # column in a VALUE function and see if that helps.

=VALUE([Questionnaire #]@row)

All comments

Paul Newcome

HOw are the numbers populated in the first sheet vs the second sheet?

jmo

@Paul Newcome

First sheet numbers in the Question # column are just a text entry (as well as the RFP Evaluation Questionnaire column)

Second sheet:

Questionnaire # column entry is generated by multi select option in a report
Question # column entry is generated by formula =[Questionnaire #]@row to turn it into a text field (thought that might help with the vlookup formula)

Paul Newcome

Am I correct in assuming the Question # Column in the first sheet is the Primary Column? If so it looks like you may be comparing text values to numerical values.

Try wrapping the formula in the second sheet's Question # column in a VALUE function and see if that helps.

=VALUE([Questionnaire #]@row)

jmo

@Paul Newcome - you did it again!

Once I created a new column and put in the =VALUE([Questionnaire #]@row) then ran the formula it worked as expected!!!

Appreciate the assist on this.

Paul Newcome

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