Names

ssjerauld · Apr 3rd, 2002, 07:14 PM

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 · Apr 3rd, 2002, 07:22 PM

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...

Apr 3rd, 2002, 07:22 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	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... __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 07:14 PM	#1
ssjerauld New Member Join Date: Mar 2002 Location: Central NY(not the park) Posts: 14	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"