Match Columns and return value
 

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.

Match Columns and return value
 

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" wrote:

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.

Match Columns and return value
 

xlm,

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



"xlm" wrote:

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" wrote:

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.