Lists

[xcalibr]

Example:
If I create a drop down list of products I produce, and let's say that each product has a different production lead time which I want to display next to the product, how can I create a function that would display the lead time for a specific product chosen from the drop down list?

Thanks.

Xcalibr

 

[Norie]

I didn't post any other formula.

If you are referring to this:

=IF(A1<>"",INDEX(Time!$B$1:$B$1000,MATCH(LEFT(A1,4),LEFT(Time!$A$1:$A$1000,4),0)),"")

then that was posted by another member, irresistible007.