selecting from dropdown--have related info auto carry over
I've created drop box for my project--I need to have all relevant info to
automatically carry over as well.
In sheet 3 i have my lists: Item#, Description, Price (all in seperate
cells)
In sheet 1 i have the dropdown set up.
When I select an Item number, how do I make sure the description and price
automatically carry over with it in their respective cells?
Thank You
Susan Christenson
|