ExcelBanter - Lookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Lookup (https://www.excelbanter.com/excel-discussion-misc-queries/117192-lookup.html)

enyaw

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?

Don Guillett

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?

All times are GMT +1. The time now is 08:19 PM.