i have 3 lists, i want them validated but shown in one cell.
col. A have 5 bill types, (Validated "Bill")
col. B have 28 product types, (Validated "product")
col. C have 12 material types, (Valided "Material")
i want in
F2 to select any of the 3 lists.
G2 to recognise them by the validation title.
H2 to categorise them payable or receivables:
attached is the example.