Hi Team,
I am looking for depended list in excel validation, can anyone please assist me on this...what formula should I use in validation list...
Input:
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>
Output:
When I select in cell A2 as grade "A" then I should only get list in B2 cell those products against to grade "A". I created the validation however, could not find what formula should I use for B2 validation field in the validation list.
Thank you,
I am looking for depended list in excel validation, can anyone please assist me on this...what formula should I use in validation list...
Input:
Grade | Products |
A | Aproduct |
B | Bproduct |
C | Cproduct |
A | Aproduct |
B | Aproduct |
C | Aproduct |
A | Aproduct |
B | Bproduct |
C | Cproduct |
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>
Output:
When I select in cell A2 as grade "A" then I should only get list in B2 cell those products against to grade "A". I created the validation however, could not find what formula should I use for B2 validation field in the validation list.
Thank you,