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?
Best Answer

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)
Answers

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

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)

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)

@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.

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!