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?

Paul Newcome

Try an INDEX/MATCH instead.

=IFERROR(INDEX({Site Code}, MATCH(Circuit@row, {Circuit}, 0)), "")

aurea

That worked, thank you!

Paul Newcome

Happy to help. 👍️

Paul Newcome

Try an INDEX/MATCH instead.

=IFERROR(INDEX({Site Code}, MATCH(Circuit@row, {Circuit}, 0)), "")

aurea

That worked, thank you!

Paul Newcome

Happy to help. 👍️