I am using Excel 2002 and I have a multisheet workbook and on the first sheet
I have created a series of 6 drop down lists pulling from predefined named
ranges. I also have limited subsequent choices based on what is selected in
the other lists. The end result is the user will be selecting parameters that
identify a product and now I am stuck with an easy way to look up the
associated part number based on the parameters they selected. Essentially,
once they have chosen the parameters in the list, I would like to create a
macro that uses those values to locate the associated part number.

I would like to know the best way to set up the database such that the macro
will use parameter A, B, C, D, E, and F to then go look up the part number
that satisfies those 6 parameters. Then, I would also like to know the best
way to write a macro to do so.

Thank you.