I have two data tables in Excel 2007.
Table A holds a bill of materials with parent and child parts laid out
suitable for use with vlookup.
Table B holds a selected list of raw materials which are child parts.

I want to lookup a parent part from a cell and search for one of its child
parts in table A if the result of the search matches one of the raw materials
in table B.

I can do simple vlookups but this is outside my knowledge.
Can anyone please point me in the right direction?
Thanks

--
Richard