| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Sizes and Concatenate
Looking for a formula to use to establish sizes in stock by just using the
item number. Would need to LOOKUP and CONCENATE to just one cell. Sample Table Below. ITEM NAME STOCK Size 1 Jumper In Stock. Small 1 Jumper In Stock. Medium 1 Jumper In Stock. Large 1 Jumper In Stock. X Large 1 Jumper In Stock. XX Large 2 Trousers In Stock. 32 Inch 2 Trousers In Stock. 34 Inch 2 Trousers In Stock. 36 Inch 2 Trousers In Stock. 38 Inch 2 Trousers No Stock. 40 Inch 3 Shirt No Stock. 15 Inch 3 Shirt In Stock. 15 1/2 Inch 3 Shirt In Stock. 16 Inch 3 Shirt In Stock. 16 1/2 Inch 3 Shirt No Stock. 17 Inch 4 Tie In Stock. Small 4 Tie In Stock. Medium 4 Tie In Stock. Large Result Item Name Sizes Available 3 Shirt 15 1/2 Inch / 16 Inch / 16 1/2 Inch |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup then concatenate | Excel Worksheet Functions | |||
| lookup and concatenate | Excel Worksheet Functions | |||
| Character sizes | New Users to Excel | |||
| How to get 2 tables (one below the other) with different sizes? | Excel Discussion (Misc queries) | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
Threaded Mode
