Populating Data From Drop-Down Item
 

Is there any way to click on an item in a drop-down box and have sets of
information populate in another cell as a result of clicking on that item?

i.e.

I have a drop-down box located in F19. Within that drop-down box is a list
of textbook titles. I would like to be able to click on a title and then have
that text's ISBN show up in G19 and also have the text price show up in H19.

How can I do this?

Thank you!

Matt

Populating Data From Drop-Down Item
 

Create a 3 column table like this:

...........A..........B..........C
1....Title......ISBN....Price
2......A.........100.......10
3......B.........422.......12
4......C.........129.......27
5......D.........666.......19

Then, entered in G19 and copied across to H19:

=VLOOKUP($F19,$A$2:$C$5,COLUMNS($F19:G19),0)

--
Biff
Microsoft Excel MVP


"MR" wrote in message
...
Is there any way to click on an item in a drop-down box and have sets of
information populate in another cell as a result of clicking on that item?

i.e.

I have a drop-down box located in F19. Within that drop-down box is a list
of textbook titles. I would like to be able to click on a title and then
have
that text's ISBN show up in G19 and also have the text price show up in
H19.

How can I do this?

Thank you!

Matt