Excel 07 fill in cells based on what is selecte in another cell

  • Thread starter Thread starter jason2444
  • Start date Start date
J

jason2444

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
 
Back
Top