Match Columns and return value

[CB]

I have 2 spreadsheets. In one spreadsheet Material.xls there are 12
worksheets. The second sheet is Purchase history.xls which contains only
worksheet 1. For each worksheet in the material workbook I need to match
Column B with Column e in the purchase history workbook sheet 1. Each sheet
in both workbooks have a different number of rows. Each time a match is
found then I would like to return the value from purchase history column e to
material workbook sheet n to column P.

Can someone please help? If I have to do this manually it will take a great
deal of time.

Thanks in advance for your help.

 

[xlm]

there are various ways of achieving this.
would you provide how your data lay out like and the expected result in col P

This would help us to understand better and provide the solution better


--
If this posting was helpful, please click on the Yes button

Thank You

cheers,

 

[CB]

xlm,

Thanks for your response. I combined the workbooks and used the lookup
function. Problem solved.