look if the attached workbook fits your needs
2009/4/30 DittoDan
>
> Greetings, I am new to this list. If this question was recently asked,
> please point me to it and forgive me for asking it so soon.
>
> I want to make an Excel table to do a task. I want a drop down (I know
> how to use Data v
Hi Dan,
You could use VLOOKUP.
The syntax is VLOOKUP(Lookup_Value,Lookup_Table,Lookup_Column,Type)
The Lookup_Value is the reference of your drop-down cell - eg B2
The Lookup_Table is as below, but needs to be in 2 columns - eg Y2:Z14
Lookup_Cloumn would be 2
Type would be 0
Hope this
On Fri, May 1, 2009 at 3:50 AM, DittoDan wrote:
>
> Greetings, I am new to this list. If this question was recently asked,
> please point me to it and forgive me for asking it so soon.
>
> I want to make an Excel table to do a task. I want a drop down (I know
> how to use Data valadation with a l
