Thank you for the help! What I'm trying to do is take a fixed start date
(4/1/06) and add 1 day (=IF(G9=0,"",WORKDAY(G9,$I$2))) to it using this
formula. The problem I have is the (1) day is the variable. If you enter
"A" it is 1 day, if you enter "B" it's 2 days and if you enter "C" it's 3
days. How do I get this to work?

AND THANK YOU, AGAIN FOR HELPING!!

"Pete_UK" wrote:

I'm not sure exactly what you want to do, but something like this would
work:

=IF(A1="A",lookup(...a1:h1...),IF(A1="B",lookup(.. .a2:h2...),
IF(A1="C",lookup(...a3:h3...),"none")))

Hope this helps.

Pete