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

[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

 

[Gord Dibben]

Visit Debra Dalgleish's site for info on Data Validation selection lists.

http://www.contextures.on.ca/xlDataVal01.html

Also see Debra's info on VLOOKUP function to pull data based on the selection
from the DV list.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP