Lookup- match

[Lewy2]

I have a work book that has up to 100 pages on the first page I have list og materials on all the other pages I import a list of parts that use those materials. I wish to find the parts in the list by matching the material name
in the parts list with the name in the material list and extract the price in a corresponing column

 

[nbrcrunch]

So somewhere in the parts list there is a field or fields indicating what materials made up this part?

If not, how do you expect to match the two lists?

 

[Lewy2]

Yes the parts list has the material name in one of it columns

 

[Peter_SSs]

Lewy2

Could you give a small sample of the data on the 'first page' and also a small sample of data on one of the other pages and tell us where the result(s) has to go?

To show sheet samples on the board, see the link at the bottom of this page to Colo's HTML Maker. Also read the ‘Sticky’ titled: 'HTML Maker FAQ (How to show your sheet on the board)' which is at the top of this ‘Excel Questions’ forum. Test it out in the ‘Test Here’ forum which is found in the ‘MrExcel Message Board Forum Index’ before trying to use it in this forum.