You can put auto filter on the header row. Once you select any item from the
drop down list the entire information regarding the item will be displayed.

Data/filter/autofiler.
--
Thanks
Suleman Peerzade


"Jennifer" wrote:

I've got a new client who has asked if I know anything about excel
workbooks/worksheets. I generally am a repair technician but wanted to see
if I could help her.

My question is, she wants a drop down list that will update among the 3
worksheets in her workbook. That I know how to set up. What I'm curious of
is if there is a way that when you choose one of the products (for example)
from the drop down list, it updates the entire row with the unit price of the
product, the description, etc. All of these things are already in a
spreadsheet. Just trying to figure out the easiest way to get it to update
automatically when something is chosen. Thanks for your help!