Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP FOR COMPANY AND EMPLOYEE
Hi All
I have a workbook having a "COMPANY INFO" sheet, a "COMPANY DATA" sheet and an "EMPLOYEE" sheet. I would like to type a company number on the "COMPANY INFO" sheet and have company info populate the upper portion of the sheet which would come from the "COMPANY DATA" sheet. This part is easy. I want the lower portion of the "COMPANY INFO" sheet to be populated with all the names associated with that company which would comfrom the "EMPLOYEE" sheet. Lets say I allow 10 lines for names on the lower portion of the "COMPANY INFO" sheet and we'll assume that there is 1 or more names, but not to exceed 10 associated with any of the companies. If for example, one of the companies has 8 employees, how can I show each of the employees only once in the lower portion that I've alloted? Keep in mind that the names may not be grouped in a line by line fashion on the "EMPLOYEE" sheet. they, more than likely, wil be scattered throughout the "EMPLOYEE" sheet. I know this is more suited to a data base but I'd like to ues it in Excel. Thanks in advance for any help you can give me. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP FOR COMPANY AND EMPLOYEE
lehigh46 has brought this to us :
Hi All I have a workbook having a "COMPANY INFO" sheet, a "COMPANY DATA" sheet and an "EMPLOYEE" sheet. I would like to type a company number on the "COMPANY INFO" sheet and have company info populate the upper portion of the sheet which would come from the "COMPANY DATA" sheet. This part is easy. I want the lower portion of the "COMPANY INFO" sheet to be populated with all the names associated with that company which would comfrom the "EMPLOYEE" sheet. Lets say I allow 10 lines for names on the lower portion of the "COMPANY INFO" sheet and we'll assume that there is 1 or more names, but not to exceed 10 associated with any of the companies. If for example, one of the companies has 8 employees, how can I show each of the employees only once in the lower portion that I've alloted? Keep in mind that the names may not be grouped in a line by line fashion on the "EMPLOYEE" sheet. they, more than likely, wil be scattered throughout the "EMPLOYEE" sheet. I know this is more suited to a data base but I'd like to ues it in Excel. Thanks in advance for any help you can give me. As you did with the company info, use VLOOKUP in 10 rows to list employees. Wrap it in an IF constuct so it returns an empty string if there's no more employees. Otherwise, more info about how the data is laid out on the Employee sheet for someone to suggest a more detailed solution. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Function? Employee Number with Employee Name | Excel Worksheet Functions | |||
Sum by company? | Excel Worksheet Functions | |||
Pop Up Box for company name | Excel Programming | |||
Calculate employee hours for employee evaluation? | Excel Worksheet Functions | |||
Fromula to take employee # out of employee name field | Excel Discussion (Misc queries) |