Hi Rick,
Look at the #catalog example on the page.
Suppose you had a table like the first table in the #catalog example
where you only brought in the Stock Numbers into the dropdown box.
Once the user has made a choice, the VLOOKUP can obtain the
description and a separate VLOOKUP can obtain the price based
on the Stock Number. value.
So you are reutilizing the same table -- if you used a table to
create your dropdown in the first place.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
Rick said:
David
Thanks for the answer. Could I impose on you a little more. After looking
at the page you refered me to I am still lost. Any chance you could give me
an example of a formula?
David McRitchie said:
by using VLOOKUP see
http://www.mvps.org/dmcritchie/excel/vlookup.htm
You can probably put that next to the employee name in the table
you use to create the dropdown, but you will still have to use
VLOOKUP..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
I have a column that has a drop down list of employee names (50ea).
I would like the cell in the next column to automaticaly insert the wage
rate for the emplyee name selected. How do I it ?
