Help with vlookup

jmo ✭✭✭✭✭✭
edited 06/16/22 in Formulas and Functions

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!