I have the Drop down ,
if I pick on C5 from drop down Std , would like on D5 to show from indirect 20% ,
is there a way to this ? or not,
or I have to add 2 different drop down, I can do that , but some users ,might not know what % goes with which category ? sheet one has all the details and sheet 2 has created drop down
can some one please help,
see attached the file,
thanks in advance for help,
Bookmarks