| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to MATCH or VLOOKUP & copy using 2 excel files
In excel2007, I'm having 2 files. In file#1, in Sheet1, Column A contains
some names. In file#2, in Sheet1, Column D contains same (Case Matching) names but in DIFFERENT ORDERS & Column E contains some numerical values against each names. In file#1, in Sheet1, in Column H, How to get the same numerical values (Column E of file#2) against the names in Column A? Note: File#2, Column D may contain ADDITIONAL names also(for which there is some value in Column E). Please help without VBA i.e. thr' excel functions Sandeep |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup retunrning a match, when not a match... | Excel Worksheet Functions | |||
| match item in 2 excel files | Excel Discussion (Misc queries) | |||
| how do I match data from two separate files in excel | Excel Discussion (Misc queries) | |||
| How to merge 2 Excel files that need to match on 2 different colum | Excel Discussion (Misc queries) | |||
| How to lock Excel files so that others can copy it & not chg it. | Excel Worksheet Functions | |||
Threaded Mode
