Posted by charles blake on January 14, 2002 2:44 PM
I'm using excel to list accounting data for payroll entries by individual employee. Each employee has a number of entries in each payroll. My accounting data list is according to employee number. I would like to add the corresponding name next to the number. I also have an employee name list that runs according to employee number. I've frustrated myself trying to find a way use an "IF" function to get the name next to the employee number. My idea was to us this sort of logic: IF, on Sheet1, cell B1 matches a number in the range B1:B700 on Sheet2, print the corresponding name from Sheet2 (adjacent cell), in cell C1 on Sheet1. In other words, I'd like to create a formula that searches for matching data in a range on another sheet and then copies data from a corresponding cell in parallel range on that sheet. I hope my explanation isn't too confusing.