Drop Down Lists
 

Hi - first timer so hopefully you will be able to understand question :-)

I have created a drop down list from a separate sheet by naming cells. These
cells contain an ODBC query so data changes everytime I refresh. This odbc
shows order lines for a one product group. There could be multiple lines for
each order. At the moment my drop down list shows those multiples but I have
a look up based on which number I select from drop down to return different
data from that line - BUT the look up only looks at first order number line
that matches that number and I need to be able to choose which line from that
order. Can I link a drop down list to give me a choice of line numbers for
the selected order from list one only? and then how can I write Vlookup to
look for that order number and that line number? Please help this is driving
me mad!
Many thanks. I look forward to hearing from you.
--
Carrie

Drop Down Lists
 

Try this as inspiration
http://pmexcelent.dk/SpecialLookup.xls


"Carrie" skrev:

Hi - first timer so hopefully you will be able to understand question :-)

I have created a drop down list from a separate sheet by naming cells. These
cells contain an ODBC query so data changes everytime I refresh. This odbc
shows order lines for a one product group. There could be multiple lines for
each order. At the moment my drop down list shows those multiples but I have
a look up based on which number I select from drop down to return different
data from that line - BUT the look up only looks at first order number line
that matches that number and I need to be able to choose which line from that
order. Can I link a drop down list to give me a choice of line numbers for
the selected order from list one only? and then how can I write Vlookup to
look for that order number and that line number? Please help this is driving
me mad!
Many thanks. I look forward to hearing from you.
--
Carrie