mambonumber5
New Member
- Joined
- Sep 17, 2015
- Messages
- 11
I'm trying to locate a number within an array of several columns and then look up a cell to the left of the array on the same row where the value has been located. For example:
<tbody>
</tbody>I want to look up D1 in B1:C3 and trace it so that it will return "nurse". I'm trying to use:
Index(A1:A3,Match(16.73, B1:C3, 0))
I would like to do this with a formula rather than by the creation of a separate table to analyze all the columns one by one. Ideas?
Much appreciated, thanks
A | B | C | D | |
1 | doctor | 3.2 | 8 | 16.73 |
2 | nurse | 14.7 | 16.73 | |
3 | purse | 1.09 | 20.3 |
<tbody>
</tbody>
Index(A1:A3,Match(16.73, B1:C3, 0))
I would like to do this with a formula rather than by the creation of a separate table to analyze all the columns one by one. Ideas?
Much appreciated, thanks