VLOOKUP FOR COMPANY AND EMPLOYEE

[lehigh46]

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.

 

[GS]

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