Use VLOOKUP() to get the specification once the value has been pick up from
the list.
--
Gary''s Student - gsnu200789


"fireman112473" wrote:

I am using a list to select an item - with that item is certain specification
that need to appear for doing come calculations. I tried with the IF
statement and it work but only for seven items and I have about 25 items that
it needs to recognize. What would an easier way of accomplishing this be?

Thanks for any help.