Drop down menu along with price

[CYNTHIA]

I have names in column A and in columnB I have rates in spreadsheet 1.

I have to make another spreadsheet (spreadsheet 2) where column A says the
name like Column A and column B in that says the rate like spreadsheet 1.

I would to have a drop down menu where I dont have to type in the name in
column A and just select their name from a drop down menu and their rates
automallically pop up in column B.

For example:
Column A ColumnB

Jane $45.00
Doe $32.00
John $12.00
Smith $45.00
Mark $90.00

I dont want to type this manually column A i want to choose from a drop down
and have all of column B's rates pop up correctly in spreadsheet 2.

 

[Farhad]

Hi,

sheet1: name range in your example (A1:B5) to for example DrupMenu

sheet2: active column A and go to the menu Data> Validation and choos List
in combobox and enter the formula below inthe source text box:
=INDEX(DrupMenu,0,1) and then click OK
enter the formula below in the cell B1:
=VLOOKUP(A1,DrupMenu,2,false) and copy drag down the formula to where ever
you need

if you couldn't do it send your filt to me i can do it for you
(e-mail address removed)

Thanks,

 

[Farhad]

Hi again,

If you don't want to see the N/A errors change the vlookup formula to:

=IF(ISNA(VLOOKUP(A1,DrupMenu,2,FALSE)),"",VLOOKUP(A1,DrupMenu,2,FALSE))

Thanks,

 

[Don Guillett]

In the source sheet name your col a items mylist.
In the destination sheet >data>validation>list>=mylist