have a file that has two sheets in sheet two are list of manufacturers in
A1-A25, manufacturer brand code in B1-B25, and brand code discount in C1-C25.
in sheet one in cell E1 i have created a data validation where there is a
drop down menu that has the list of manufacturers from A1 -A25 from sheet
two. how do i set it up so from the drop down list if i select the
manufacturer that in A1 on sheet two that the information in sheet 2 in cells
B1 and C1 will be put into cells F1 and G1 in sheet 1