Hi Guys,
I need your expert help in one formula.
So in below table i have headers,"YES" &"NO" and value of the respective YES and no.
What i am trying to achieve here is in input cell when i enter Yes so it should display all YES value in single cell (it should be like YES-111,YES-333,YES-555,YES-777 and when No will be in input cell it should mentioned No-222,No-444,No-666 and so on...
<tbody>
</tbody>
<tbody>
</tbody>
I tried many ways of Hlookup and others but no luck with my limited knowledge, so thought to ask experts now.
Thank you in advance for your help
I need your expert help in one formula.
So in below table i have headers,"YES" &"NO" and value of the respective YES and no.
What i am trying to achieve here is in input cell when i enter Yes so it should display all YES value in single cell (it should be like YES-111,YES-333,YES-555,YES-777 and when No will be in input cell it should mentioned No-222,No-444,No-666 and so on...
<tbody>
</tbody>
A | B | C | D | E | F | G | H | I | J |
YES | NO | YES | NO | YES | NO | YES | NO | YES | NO |
111 | 222 | 333 | 444 | 555 | 666 | 777 | 888 | 999 | 521 |
<tbody>
</tbody>
I tried many ways of Hlookup and others but no luck with my limited knowledge, so thought to ask experts now.
Thank you in advance for your help