Vlookup or If Statement?
 

I have three worksheets. One is where I enter all my employee data, the
second is a template which is automatically populated when I input the
employee name in the third sheet. Also, the third sheet contains a list of
employee names and a macro that will automatically populate and print the
template when I put an "X" in the column next to the employee name. So if I
wanted to print twenty specific employee templates, I can check off the
twenty that I need to print.

Now my problem is, not all employees have the same data. For example, some
employees are paid on a weekly basis, some bi-weekly and some monthly. In my
employee datasheet, there are 3 columns to input this information and only
one column is filled in. Rather than to have my template show weekly,
bi-weekly and monthly, I want to show just weekly if the employee is paid
weekly, or just show bi-weekly etc. Is there anyway to tell excel to look in
those columns for a number, and to show that name (either weekly, bi-weekly
or monthly)?

Hope I am clear. Thanks for any help.

Vlookup or If Statement?
 

On May 3, 5:07 pm, Confused
wrote:
I have three worksheets. One is where I enter all my employee data, the
second is a template which is automatically populated when I input the
employee name in the third sheet. Also, the third sheet contains a list of
employee names and a macro that will automatically populate and print the
template when I put an "X" in the column next to the employee name. So if I
wanted to print twenty specific employee templates, I can check off the
twenty that I need to print.

Now my problem is, not all employees have the same data. For example, some
employees are paid on a weekly basis, some bi-weekly and some monthly. In my
employee datasheet, there are 3 columns to input this information and only
one column is filled in. Rather than to have my template show weekly,
bi-weekly and monthly, I want to show just weekly if the employee is paid
weekly, or just show bi-weekly etc. Is there anyway to tell excel to look in
those columns for a number, and to show that name (either weekly, bi-weekly
or monthly)?

Hope I am clear. Thanks for any help.

Sorry I can't be of much help here, (my time is getting short) but it
sounds like you could use a Match and Index function.

The internal help file for both Match and Index is really good and
better laid out then I could for you here.

-LT

Vlookup or If Statement?
 

Hi

If you could use a single column instead of three to determine the
frequency of pay it would be easier.
Have one column, and either enter 1 or 2 or M.
Then, assuming it was column F holding this data, you could use
something like
=IF(F2="","",IF(F2=1,"Weekly",IF(F2=2,"Bi-Weekly","Monthly)))
--
Regards

Roger Govier


"Confused" wrote in message
...
I have three worksheets. One is where I enter all my employee data,
the
second is a template which is automatically populated when I input the
employee name in the third sheet. Also, the third sheet contains a
list of
employee names and a macro that will automatically populate and print
the
template when I put an "X" in the column next to the employee name.
So if I
wanted to print twenty specific employee templates, I can check off
the
twenty that I need to print.

Now my problem is, not all employees have the same data. For example,
some
employees are paid on a weekly basis, some bi-weekly and some monthly.
In my
employee datasheet, there are 3 columns to input this information and
only
one column is filled in. Rather than to have my template show weekly,
bi-weekly and monthly, I want to show just weekly if the employee is
paid
weekly, or just show bi-weekly etc. Is there anyway to tell excel to
look in
those columns for a number, and to show that name (either weekly,
bi-weekly
or monthly)?

Hope I am clear. Thanks for any help.