Blcook6383
New Member
- Joined
- Apr 2, 2018
- Messages
- 5
I need to match a value in an array to a value in the first row. See Below:
<tbody>
</tbody>
<colgroup><col><col><col><col span="3"></colgroup><tbody>
</tbody>For example, I want to be able to lookup "Pediatric Dental" and obtain "Voluntary (2)".
There are 2 caveats:
1 - "Pediatric Dental" can show up in other columns and rows below the first row (not just the second row of column four) and
2 - "Pediatric Dental" will only show in one place in the entire array below the first row.
I've used "=INDEX($C$43:$H$43,1,MATCH("Pediatric Dental",$C$44:$H$47,0))" and
"=INDEX($C$43:$H$43,,MATCH("Pediatric Dental",INDEX($C$44:$H$47,MATCH("Pediatric Dental",$C$44:$H$47,0),),0))"
but the problem is that I cannot match from an array it seems.
Medical | Dental | Voluntary | Voluntary (2) | Voluntary (3) | Voluntary (4) |
Medical | Dental | Pediatric Dental | Basic Life | AFLAC | |
STD | |||||
LTD | |||||
<tbody>
</tbody>
<colgroup><col><col><col><col span="3"></colgroup><tbody>
</tbody>
There are 2 caveats:
1 - "Pediatric Dental" can show up in other columns and rows below the first row (not just the second row of column four) and
2 - "Pediatric Dental" will only show in one place in the entire array below the first row.
I've used "=INDEX($C$43:$H$43,1,MATCH("Pediatric Dental",$C$44:$H$47,0))" and
"=INDEX($C$43:$H$43,,MATCH("Pediatric Dental",INDEX($C$44:$H$47,MATCH("Pediatric Dental",$C$44:$H$47,0),),0))"
but the problem is that I cannot match from an array it seems.