INDEX/MATCH
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
-
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!
-
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)
