Hi All,
Could you please help me with the following(not sure if vba is needed or a regular function would do it):
I have a table like this(with exponentially more data) and on a separate sheet i want to set up a search functionality where in if i enter a specific account number in a cell(for eg A1) excel does a lookup in this table for that number, and for that row, all the headers(rules) of "NOK" values, are listed one below the other.
<tbody>
</tbody>
Example:
<colgroup><col><col></colgroup><tbody>
</tbody>
I am a new excel user and would really appreciate the help.
Thanks a ton!
Could you please help me with the following(not sure if vba is needed or a regular function would do it):
I have a table like this(with exponentially more data) and on a separate sheet i want to set up a search functionality where in if i enter a specific account number in a cell(for eg A1) excel does a lookup in this table for that number, and for that row, all the headers(rules) of "NOK" values, are listed one below the other.
A/c No | Rule 1 | Rule 2 | Rule 3 | Rule 4 | Rule 5 | Rule 6 | Rule 7 |
123 | NOK | NOK | NOK | NOK | NOK | NOK | NOK |
124 | NOK | NOK | NOK | NOK | NOK | NOK | |
125 | NOK | NOK | NOK | NOK | |||
126 | NOK | NOK | NOK | NOK | NOK | NOK | |
127 | |||||||
128 | NOK | NOK | NOK | NOK | NOK | NOK | |
129 | NOK | NOK | NOK | NOK | NOK | ||
130 | |||||||
131 | NOK | NOK | NOK | NOK | |||
132 | NOK | NOK | NOK | NOK | NOK | NOK | NOK |
133 | NOK | NOK | NOK | NOK | NOK | NOK | |
134 | NOK | NOK | NOK | NOK | NOK | NOK |
<tbody>
</tbody>
Example:
A/c Number(Configurable) | Rules NOK |
131 | Rule 3 |
Rule 4 | |
Rule 5 | |
Rule 7 |
<colgroup><col><col></colgroup><tbody>
</tbody>
I am a new excel user and would really appreciate the help.
Thanks a ton!
Last edited: