| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return proper match from three columns | Excel Worksheet Functions | |||
| Match 2 Columns, Return 3rd, Differing Match Types | Excel Worksheet Functions | |||
| match 2 columns and return value of another | Excel Worksheet Functions | |||
| Match two columns, return a third piece of data | Excel Discussion (Misc queries) | |||
| Match data in 2 columns and return data from 3rd column | Excel Worksheet Functions | |||
Threaded Mode
