How to auto-populate data based on cell value
Hi All,
Need help.
I have list of product name for which the quality test parameters are fixed. I want to know if we have a dropdown for list of products, how to auto populate the associated list of quality test parameters.
E.g.
Product Names: 5711 & 8105
5711 has below list of parameters which should auto populate upon selecting 5711.
Sp. Gr. @ 25C
% MEA
%NH3
8105 has below list of parameters which should auto populate upon selecting 8105
Gardner color
% Polymer Solids
Sp. Gr. @ 25C
Viscosity 25 C (#2 ,30 rpm)
pH @ 25C
Dimethylamine,ppm
Epichlorohydrin,ppm
1,3-Dichloro-2-propanol
2,3-Dichloro-1-propanol
3-Chloro-1-,2-Propanol,ppm
Total Chlorinated Residual,ppm
I.V
Gel Number
I hope I could explain the query clearly.
Thanks You.
Amit
|