Prev: Toggling xlVeryHidden
Next: Generate random numbers - Using initial seed
From: primed on 13 Apr 2010 01:05
Hi,

Is there any way of simplifying this formula, mainly the lookup part.

=IF(COUNTIFS('EOT Register'!$D$2:$D$92,Program!C16,'EOT
Register'!$O$2:$O$92,0)=0," ","EOT under review - "&LOOKUP(C17,'EOT
Register'!$D$2:$D$92,'EOT Register'!$B$2:$B$92)& " " &LOOKUP(C17,'EOT
Register'!$D$2:$D$92,'EOT Register'!$F$2:$F$92 & " " &LOOKUP(C17,'EOT
Register'!$D$2:$D$92,'EOT Register'!$H$2:$H$92)&" days"))

Thanks
Primed
From: ozgrid.com on 13 Apr 2010 01:24
You could Define X LOOKUP Functions as Named Formulas.
http://www.ozgrid.com/Excel/named-formulas.htm



--
Regards
Dave Hawley
www.ozgrid.com
"primed" <primed(a)discussions.microsoft.com> wrote in message
news:933357E4-4962-43FB-8394-EB0F6086D731(a)microsoft.com...
> Hi,
>
> Is there any way of simplifying this formula, mainly the lookup part.
>
> =IF(COUNTIFS('EOT Register'!$D$2:$D$92,Program!C16,'EOT
> Register'!$O$2:$O$92,0)=0," ","EOT under review - "&LOOKUP(C17,'EOT
> Register'!$D$2:$D$92,'EOT Register'!$B$2:$B$92)& " " &LOOKUP(C17,'EOT
> Register'!$D$2:$D$92,'EOT Register'!$F$2:$F$92 & " " &LOOKUP(C17,'EOT
> Register'!$D$2:$D$92,'EOT Register'!$H$2:$H$92)&" days"))
>
> Thanks
> Primed

 | 
Pages: 1
Prev: Toggling xlVeryHidden
Next: Generate random numbers - Using initial seed