INDEX/MATCH

Options

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?

Answers

  • David Joyeuse
    David Joyeuse ✭✭✭✭✭
    Options

    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
    Options

    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)