Related:
- Inputbox in excel - how to?
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- How to change date format in excel - Guide
- How to change author in excel - Guide
- Gif in excel - Guide
1 response
Hi Jesperhs,
Since you haven't given exact lists, let me give you an example.
Range A1:C2:
aa 12 !@
bb 34 #$
Select cell A4, goto top menus data > validate.
Allow: List
Source: A1:A2
Select cell B4, goto top menus data > validate.
Allow: List
Source: =IF(A4="aa",B1:B2,C1:C2)
When you choose aa from the first dropdown list the second one will let you choose either 12 or 34.
When you choose bb from the first dropdown list the second one will let you choose either !@ or #$.
With more categories you can use nested IF's.
Hopefully this gives you an idea how to tackle this query.
Best regards,
Trowa
Since you haven't given exact lists, let me give you an example.
Range A1:C2:
aa 12 !@
bb 34 #$
Select cell A4, goto top menus data > validate.
Allow: List
Source: A1:A2
Select cell B4, goto top menus data > validate.
Allow: List
Source: =IF(A4="aa",B1:B2,C1:C2)
When you choose aa from the first dropdown list the second one will let you choose either 12 or 34.
When you choose bb from the first dropdown list the second one will let you choose either !@ or #$.
With more categories you can use nested IF's.
Hopefully this gives you an idea how to tackle this query.
Best regards,
Trowa
