VLOOKUP matching text, referencing another sheet

Sarah Nielsen

I am trying to match a vendor name between two sheets and if it is found to display a risk rating from the other sheet. I am getting the error message #UNPARSEABLE with the formula below. What am I doing wrong?

=VLOOKUP("[Vendor Name]@row",{Vendor Risk Rating Summary Range 1,{Vendor Risk Rating Summary Range 2},false})

Sarah

Sarah Nielsen

I figured it out, no further help needed on this question.

Sarah Nielsen

I figured it out, no further help needed on this question.

Genevieve P.

Hi @Sarah Nielsen

I'm glad you figured it out!

For anyone else with a similar issue, it looks like Sarah had quotes around the cell reference "[Vendor Name]@row" which would need to be removed: [Vendor Name]@row

Additionally, it looks like there are two cross-sheet references merged into one:

{Vendor Risk Rating Summary Range 1,{Vendor Risk Rating Summary Range 2}

which should look more like:

{Vendor Risk Rating Summary Range 1}

Here are some Help Articles that may help when building out formulas:

• Formulas: Reference Data from Other Sheets
• Create a Cell or Column Reference in a Formula
• VLOOKUP Function

Cheers,

Genevieve