AlejandroD
New Member
- Joined
- Apr 22, 2019
- Messages
- 2
Hi Everyone,
I am trying to figure out how to write an Hlookup or an Index(Match) formula that shows multiple results. I want to search multiple values horizontally instead of vertically. Please see below as an example:
Criteria:
<colgroup><col span="4"></colgroup><tbody>
</tbody>
Desired result:
I would like to add a formula on column E (CheckinID) that finds the values ND100_IS, ND200_IS, ND700_IS on each row. If the value is not found then the cell should be blank.
Hope it makes sense, thanks in advanced for your help.
I am trying to figure out how to write an Hlookup or an Index(Match) formula that shows multiple results. I want to search multiple values horizontally instead of vertically. Please see below as an example:
Criteria:
<colgroup><col span="4"><col></colgroup><tbody> </tbody> |
<colgroup><col span="4"></colgroup><tbody>
</tbody>
Desired result:
I would like to add a formula on column E (CheckinID) that finds the values ND100_IS, ND200_IS, ND700_IS on each row. If the value is not found then the cell should be blank.
Hope it makes sense, thanks in advanced for your help.