If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|