DROP DOWN MENU

  • Thread starter Thread starter TREY
  • Start date Start date
T

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
 
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
 
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..
 
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..

.
Click to expand...
 
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.
 
Back
Top