Auto-fill results from List selection

**buffiness** · 01-09-2008, 01:45 AM

Hi there,

What I am wanting to do in Excel is after selecting an item from a list box, the rest of cells next to it are automatically filled from other information in the worksheet.
eg. When a particular type of Cinema is selected from the List in the top sheet, then the other relevant information (seats, all costs) are automatically filled in.

Images:
Top Sheet -
\1

2nd worksheet -
\1

If I'm not explaining myself very well, please let me know and I'll try to make more sense!
thanks in advance for any help that anyone is able to give me!

**Paul** · 01-09-2008, 01:54 AM

Hi Buffiness,

You can use VLOOKUP functions in columns D:G to pull the relevant data.

For example, in D6 you could use:

Please Login or Register  to view this content.

This would check the Cinema Costs Sheet, column A, for the value in C6 and return the second column's value (the 2 determines which column you want returned).

So in E6, you would use:

Please Login or Register  to view this content.

**buffiness** · 01-09-2008, 07:07 PM

Thank you so much for that!
It's working perfectly!

Auto-fill results from List selection

LinkBack

Thread Tools

Rate This Thread

Display

Auto-fill results from List selection

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions