A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Drop Downs and lookups from other sheets



 
 
Thread Tools Display Modes
  #1  
Old April 19th, 2010, 03:17 PM posted to microsoft.public.excel.worksheet.functions
TheDrescher
external usenet poster
 
Posts: 16
Default Drop Downs and lookups from other sheets

I have a workbook where the front sheet is a display page and the three
sheets behind are reserved for data tables. What I want to do is have one
cell in the front page which is a drop down and selects names from one of the
tables on the other sheets. From there I can use Vlookup to populate the
info from the tables on the front page based on that name. The problem is I
can't seem to get this list of names from another sheet. Every time I try, I
get an error. How would I do this? thanks!
  #2  
Old April 19th, 2010, 03:59 PM posted to microsoft.public.excel.worksheet.functions
eduardo
external usenet poster
 
Posts: 2,131
Default Drop Downs and lookups from other sheets

Hi,.

first insert a name for your list in the other sheet, go to insert, name,
for example use "mylist", choose the range in the other sheet then go to data
validation, in the allow field enter List, source enter

=mylist



"TheDrescher" wrote:

I have a workbook where the front sheet is a display page and the three
sheets behind are reserved for data tables. What I want to do is have one
cell in the front page which is a drop down and selects names from one of the
tables on the other sheets. From there I can use Vlookup to populate the
info from the tables on the front page based on that name. The problem is I
can't seem to get this list of names from another sheet. Every time I try, I
get an error. How would I do this? thanks!

  #3  
Old April 19th, 2010, 05:28 PM posted to microsoft.public.excel.worksheet.functions
Pete_UK
external usenet poster
 
Posts: 8,780
Default Drop Downs and lookups from other sheets

Are you using data validation to give you the drop-down of names? You
will need something like this, assuming the drop-down is in A1 and
your sought-value is in B1:

=VLOOKUP(B1,INDIRECT(A1),2,0)

Hope this helps.

Pete

On Apr 19, 3:17*pm, TheDrescher
wrote:
I have a workbook where the front sheet is a display page and the three
sheets behind are reserved for data tables. *What I want to do is have one
cell in the front page which is a drop down and selects names from one of the
tables on the other sheets. *From there I can use Vlookup to populate the
info from the tables on the front page based on that name. *The problem is I
can't seem to get this list of names from another sheet. *Every time I try, I
get an error. *How would I do this? *thanks!


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.