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
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!