INDEX/MATCH

Stephen Hindes

In VLOOKUP I have set a range to ge it to work, Range 3.

I am trying to convert this to a INDEX/MATCH and having trouble.

the cell to compart is in column 3 but the data in need is in column 1.

=VLOOKUP([System Number]77, {Schedule Range 3}, 4, false)

=MATCH([System Number]77, {Schedule Range 3}, 0) = 1723

I have only about 70 rows, in the range I have 40 columns.

the data i am testing on is in row-44.

can you help me in doing this Index/Match?

Find more posts tagged with

Accepted answers

All comments

David Joyeuse

Hi @Stephen Hindes

You have to do it like this:

=INDEX({Schedule Range 1}, MATCH([System Number]@row, {Schedule Range 3},0))

Basically INDEX works like this:

=INDEX({Value to return}, {Line Number in the range}, {column number in the range})

Column being optional.

As a whole, it's better to work with single column ranges.

Hope it helped!

Stephen Hindes

that works, somewhat.

the other issue I had is the the range i gave it was a group of columns not just one, but i fixed it and you were a LOT of help.

here is what it looks like not, if this will help others.

=INDEX({Schedule Range 3}, MATCH([System Number]@row, {Schedule Range 4}, 0), 1)

Sign in to join the conversation!

Quick Links

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.