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
Check out the Formula Handbook template!