Vlookup Error

Trying to create a vlookup that will check for a circuit on the first sheet and return the site code from the second sheet, but I keep getting the Invalid Data Type error.

=VLOOKUP(Circuit@row, {Site Bandwidth Range Circuit}, {Site Bandwidth Range Site Code}, false)

Lookup Sheet

What silly thing am I doing wrong?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!