Hi - I have managed to do it with a Vlookup by sorting parts in descending
order so it picks up first in list which is newest and then used MID to
extract numbers and add 1.
Manythanks for your help.
--
Carrie


"Gary''s Student" wrote:

What you need is easy if the column of parts were inverted. We could use a
formula with VLOOKUP Is this approach O.K.??
--
Gary''s Student - gsnu200728


"Carrie" wrote:

Hi thanks for quick response. This does get information I need but I want to
return information so that when someone selects characters 1 & 2 for code
from validation lists e.g. 3 R then it automatically tells them next
available number for that type of part. Those first two characters can be
different each time.

--
Carrie


"Gary''s Student" wrote:

Data Filter Autofilter Custom Begins with
--
Gary''s Student - gsnu200728