Names

[ssjerauld]

Hello Again!
I am linking B2 "Employee #" to B4 "Employee Name" with =IF(B2=11,"Ed",IF(B2=230,"Scott")) but only up to 7 times. I need to use up to 30+- #'s per worksheet.
Next I would like to have date in C4 written as: 3/22/02 auto fill 1 weeks days in D4 - D10 as Month/Day i.e. 3/22~3/23~324~3/25~3/26~3/27~3/28
I am using MSOffice97,Excel
Thanks,
Scott, aka"230"

 

[Anne Troy]

For the first part, check out my downloadable VLOOKUP at:

http://www.thewordexpert.com/tipwarez.htm#MyVlookup

D4 to D10 need to be formatted as you show, then:

In D4, type =if(isblank(C4),"",C4)
In D5, type =if(isblank(C4),"",D4+1)
In D6, type =if(isblank(C4),"",D5+1)
In D7, type =if(isblank(C4),"",D6+1)

You get the idea...