Related:
- Inputbox in excel - how to?
- How to take screenshot in excel - Guide
- Number to words in excel - Guide
- How to change author in excel - Guide
- Dd-mm-yyyy format in excel - Guide
- Excel free download - Download - Spreadsheets
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