I need to validate multiple cells in to one dropdown box. example: validate
a3:a23 (item #), b3:b18 (descriptions) and c3:c27 (prices) into one drop box.
I would like to type a item number in validated a4 and autofill a
description in b4 and a price in c4. Thanks

VLOOKUP formulas in B and C will do the trick.

Use Data Validation for in-cell drop-down for selecting an item and VLOOKUP
for filling in the other cells.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

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

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

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP




On Mon, 9 Apr 2007 09:34:00 -0700, shad wrote:

I need to validate multiple cells in to one dropdown box. example: validate
a3:a23 (item #), b3:b18 (descriptions) and c3:c27 (prices) into one drop box.
I would like to type a item number in validated a4 and autofill a
description in b4 and a price in c4. Thanks

IF (and it isn't clear to me from your posting as your ranges are different
sizes) you have a table of item, with corresponding description and price,
then:

Use Data Validation with Item list (A3:A23) in your first cell (can it be
A4? as list is A3:A23?)
use:

Item# is in cell A4?

B4 ? =VLOOKUP(Item#,A:C,2,0) to get description

=VLOOKUP(A4,A:C,2,0) to get description ????

C4 ? =VLOOKUP(Item#,A:C,3,0) to get price


"shad" wrote:

I need to validate multiple cells in to one dropdown box. example: validate
a3:a23 (item #), b3:b18 (descriptions) and c3:c27 (prices) into one drop box.
I would like to type a item number in validated a4 and autofill a
description in b4 and a price in c4. Thanks

I don't understand what i'm doing. I'm not sure I typed in the correct cells.
I could not get it to work. I would like to make an invoice and when I type
in an item number in a cell under A the description will autofill in a cell
under B and the price autofill in a cell under C. Please explane in detail
how to set this up. Thanks in advance for any help.

"Toppers" wrote:

IF (and it isn't clear to me from your posting as your ranges are different
sizes) you have a table of item, with corresponding description and price,
then:

Use Data Validation with Item list (A3:A23) in your first cell (can it be
A4? as list is A3:A23?)
use:

Item# is in cell A4?

B4 ? =VLOOKUP(Item#,A:C,2,0) to get description

=VLOOKUP(A4,A:C,2,0) to get description ????

C4 ? =VLOOKUP(Item#,A:C,3,0) to get price


"shad" wrote:

I need to validate multiple cells in to one dropdown box. example: validate
a3:a23 (item #), b3:b18 (descriptions) and c3:c27 (prices) into one drop box.
I would like to type a item number in validated a4 and autofill a
description in b4 and a price in c4. Thanks