Hi,

I have a spreadsheet (excel 2000) and it has headings and subheadings in
column A, with values in column B. As shown below:

AAA
Product 1 20
Product 2 30
Product 3 40
BBB
Product 1 10
Product 2 15
Product 3 20

What I need is to perform a lookup or search that recognises the heading,
and finds the correct subheading, and displays the value next to that
subheading. i.e.:

If I want "BBB" heading, and "Product 1" subheading, the value displayed
would be 10.

I have been trying to use the find function to find the heading, but cannot
find code to search the Subheading:
Cells.Find("BBB", , xlValues).Activate

I have been rattling my brain trying to find any formula or code to perform
this, any help would be much appreciated.

Thank you in-advance.
Matt