DROP DOWN MENU

[TREY]

i have a drop down menu of items - presently in a
validation list... i have corresponding serial#'s from
another list that i want to populate an adjoing cell on
my worksheet, when one of the items is chosen... can
someone please give me an idea how i could go about doing
this...
thanks
trey

 

[Debra Dalgleish]

There's a sample file on my web site that uses Data Validation and
VLookup to complete an order form. You could use the same technique for
your worksheet:

http://www.contextures.com/excelfiles.html

Look for the heading: Order Form (DataValOrder.xls)

 

[RagDyer]

Say your list of items and corresponding serial numbers is in Y1:Z10,
With the items in Y and numbers in Z.

Say the drop down cell is A5,And you want the serial number to display in
B5.
Enter this in B5:

=VLOOKUP(A5,Y1:Z10,2,0)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


i have a drop down menu of items - presently in a
validation list... i have corresponding serial#'s from
another list that i want to populate an adjoing cell on
my worksheet, when one of the items is chosen... can
someone please give me an idea how i could go about doing
this...
thanks
trey

 

[trey]

i tried that and it returns #n/a
help
trey

 

[trey]

i think i forgot to add both of the lists are on a
different sheet..

 

[RagDyer]

If your list was on sheet 2, this would be the syntax:

=VLOOKUP(A5,Sheet2!Y1:Z10,2,0)

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

i think i forgot to add both of the lists are on a
different sheet..

 

[TREY]

THATS NOT WORKING... it prompts for a file...

-----Original Message-----
If your list was on sheet 2, this would be the syntax:

=VLOOKUP(A5,Sheet2!Y1:Z10,2,0)

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

i think i forgot to add both of the lists are on a
different sheet..

.

 

[Dave Peterson]

What's the name of the worksheet?

=vlookup(a5,'yoursheetnamegoeshere'!y1:z10,2,0)

If the =vlookup() returns #n/a, you can hide it with:

=if(iserror(vlookup()),"",vlookup())

Replace my shortened version of vlookup's with the one you need.