| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on which function to use
See this:
http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP wrote in message ... I have two files files that contain employee information. Each file has an employee number. I wish to compare the employee records in the two files using the employee number and copy selected fields to one of the files. For example, File #1 A B C D E 1 32 Bob 2 65 Sam 3 77 Cal File #2 A B C D E 1 32 Smith 2 65 Jones 3 77 Doe I would like a function that would compare the two files using column A. The outcome would be that the entries in column B of file #2 would be placed in coulmn C of file 1 assuming the ID's found in coulmn 1 match. Which function would I use? And how would the formula be written in the example above? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function question | Excel Worksheet Functions | |||
| question about ABS Function | Excel Worksheet Functions | |||
| IF Function question. | Excel Worksheet Functions | |||
| Function question | Excel Worksheet Functions | |||
| Function question | Excel Worksheet Functions | |||
Hybrid Mode
