Lookup- match

Lewy2

New Member
Joined
Mar 16, 2002
Messages
19
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
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
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

New Member
Joined
Mar 16, 2002
Messages
19
Yes the parts list has the material name in one of it columns
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,483
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,229
Messages
5,571,019
Members
412,354
Latest member
Stj99
Top