Prev: VBA: How to match two sets?
Next: Run Time Error '1004' Application or Onject-defined
From: primed on 20 Apr 2010 23:22
Hi,

I need help to improve this formula to display multiple instances of the
unapproved EOT's. Extension of Times that are not approved. ie....... 'EOT
Register'!$O$2:$O$92,0)=0

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

'EOT Register'!$B$2:$B$92 - contains a unique number, if thats required.

Thanks in advance
Primed
 | 
Pages: 1
Prev: VBA: How to match two sets?
Next: Run Time Error '1004' Application or Onject-defined