I want to identify a unique part number for a light unit given that there are
three variables associated with it. The variables are voltage, color, and
steady/flashing.

Each voltage has bulbs of different colors; each voltage and color has
alternatives of steady or flashing. So I really need to 'nest' my lookups.
However, I am not having any luck figuring out how to do it. The IF(AND ...)
function looks likely, but I would have to make a very complicated formula.

Seems I am making the atsk harder than I need to. In a way, I want to
emulate the Online Autoparts application. When you have entered the Make
(Ford Truck) the display changes and asks you for Year. Then it changes again
and asks you for Body details. Finally it changes again and asks for Engine
Size.

Any suggestions?

Many thanks. (Btw, I am using Excel 2003)

Mike