$$Excel-Macros$$ Re: Part Numbers

2009-05-01 Thread Fabio Lemos
look if the attached workbook fits your needs 2009/4/30 DittoDan dbovin...@ovonic.com 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

$$Excel-Macros$$ Re: Part Numbers

2009-04-30 Thread Harmeet Singh
On Fri, May 1, 2009 at 3:50 AM, DittoDan dbovin...@ovonic.com 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

$$Excel-Macros$$ Re: Part Numbers

2009-04-30 Thread Dave Bonallack
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