Drop down menu along with price
 

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.

Drop down menu along with price
 

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


Thanks,


--
Farhad Hodjat


"CYNTHIA" wrote:

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.

Drop down menu along with price
 

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,
--
Farhad Hodjat


"Farhad" wrote:

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


Thanks,


--
Farhad Hodjat


"CYNTHIA" wrote:

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.

Drop down menu along with price
 

In the source sheet name your col a items mylist.
In the destination sheet datavalidationlist=mylist


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"CYNTHIA" wrote in message
...
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.