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?

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)