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)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 392 Global Discussions
- 213 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives