Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup one value and return multiple corresponding values
Hi - I have tried some formulas but not really sure what I'm doing so need
help please. I want to be able to find the next available sequential number for a new part from a list. This number is digits 3-5 of a code. e.g. 3R001A. Parts can start with a variety of numbers/letters depending of processes and materials e.g. 1-5, F/N/X/D/ E/P/R/H/B, followed by 3 digit sequential code. I want to be able to look up say all codes starting with '3R' and find the next sequential number available for new part. I have an exported list of all current parts. I thought I could do this by using lookup function unless any one knows of a better way and retuning multiple corresponding values and then adding 1. Many thanks, Carrie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup one value and return multiple corresponding values
Data Filter Autofilter Custom Begins with
-- Gary''s Student - gsnu200728 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup one value and return multiple corresponding values
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup one value and return multiple corresponding values
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup one value and return multiple corresponding values
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup and Return Multiple Values | Excel Worksheet Functions | |||
Lookup and Return Multiple Values | Excel Discussion (Misc queries) | |||
lookup 1 value and return multiple corresponding values | Excel Worksheet Functions | |||
Lookup one value and return multiple corresponding values | Excel Discussion (Misc queries) | |||
how to lookup a value and return multiple corresponding values | Excel Worksheet Functions |