roundaboutrc
New Member
- Joined
- Jul 24, 2019
- Messages
- 5
Hello everyone,
Not sure if this is possible, but I think to think "All Things are Possible", so I figured I would ask. I have some data where the first column is category then every column after that is id's for that category.
<tbody>
</tbody>
I am looking for a formula to lookup an ID say in this case 1832 and return Cat 4, where the ID could be located anywhere from B1:D5. I have tried Index and Match [=Index(A1:A5,Match(1832,B1:D5,0))], but it doesn't like the B1:D5 it appears Match can only look at a single row or column.
Not sure if this is possible, but I think to think "All Things are Possible", so I figured I would ask. I have some data where the first column is category then every column after that is id's for that category.
A | B | C | D | |
1 | Cat 1 | 1000 | 1200 | 1450 |
2 | Cat 2 | 1002 | 1305 | |
3 | Cat 3 | 2000 | ||
4 | Cat 4 | 1503 | 1832 | 1900 |
5 | Cat 5 | 1235 |
<tbody>
</tbody>
I am looking for a formula to lookup an ID say in this case 1832 and return Cat 4, where the ID could be located anywhere from B1:D5. I have tried Index and Match [=Index(A1:A5,Match(1832,B1:D5,0))], but it doesn't like the B1:D5 it appears Match can only look at a single row or column.