Excel Drop Down List
 

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!

Excel Drop Down List
 

Once you have the drop down list, use VLOOKUPS for the other data.
--
John C


"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!

Excel Drop Down List
 

Is this an easy formula? It will take all cells that I need and put on a
separate worksheet?

"John C" wrote:

Once you have the drop down list, use VLOOKUPS for the other data.
--
John C


"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!

Excel Drop Down List
 

I'd use data|validation for the dropdown (say in A1).
Visit Debra Dalgleish's site for lots of info:
http://www.contextures.com/xlDataVal01.html

Then I'd build a table on sheet2 that had the stuff I needed. Column A would
contain the key value (the same list the dropdown uses).

Then you can retrieve the first value (column B of the table) with something
like:

=if($a$1="","",vlookup($a$1,sheet2!a:e,2,false)

the 3rd column:
=if($a$1="","",vlookup($a$1,sheet2!a:e,3,false)
....
The 5th column:
=if($a$1="","",vlookup($a$1,sheet2!a:e,5,false)

It doesn't do any error checking, since you used data|validation in A1 and you
can't make a typo!!!

Debra Dalgleish has lots of notes on =vlookup() he
http://www.contextures.com/xlFunctions02.html
and
http://contextures.com/xlFunctions02.html#Trouble

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!

--

Dave Peterson

Excel Drop Down List
 

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!