Vlookup Error
aurea
ββ
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
-
Try an INDEX/MATCH instead.
=IFERROR(INDEX({Site Code}, MATCH(Circuit@row, {Circuit}, 0)), "")
-
That worked, thank you!
Answers
-
Try an INDEX/MATCH instead.
=IFERROR(INDEX({Site Code}, MATCH(Circuit@row, {Circuit}, 0)), "")
-
That worked, thank you!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!