| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup
In a worksheet I have a list of parts. Some of these parts have a total part
amount. Is there a way that if I am looking up a part that I would be able to return just the total part amount. Part 1 Part 1A Part 1B Part 1 Total Part 2 Part 3 Part 3A Part 3 Total When I reference "Part 1" I want to be able to return "Part 1 Total". Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup
try this idea where c1 is 1 or 2 or 222222
=MATCH("part"&C1&" total",D:D) -- Don Guillett SalesAid Software "enyaw" wrote in message ... In a worksheet I have a list of parts. Some of these parts have a total part amount. Is there a way that if I am looking up a part that I would be able to return just the total part amount. Part 1 Part 1A Part 1B Part 1 Total Part 2 Part 3 Part 3A Part 3 Total When I reference "Part 1" I want to be able to return "Part 1 Total". Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP a text string created from IF statement | Excel Discussion (Misc queries) | |||
| Another way to lookup data | Excel Worksheet Functions | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Linear Mode
