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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reverse pasting rows with alternate blank cells 0
Formula to populate a drop down list based on the selection of ano 1
Copy/Paste formulas in merged cells 2
Data Validation and drop-down list using IF, AND and what else? 8
Need data result in last cell of array that contains blank cells 2
Please help. This is way too tough for me. 2
creating nested formulas from drop down box 5
Filling Out Cells Based on Data Validation 1

Top