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?

Find more posts tagged with

Accepted answers

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. 👍️

All comments

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. 👍️

Sign in to join the conversation!

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.