View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MR MR is offline
external usenet poster
 
Posts: 7
Default 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