I'd try:
=if(sumproduct((ytd!C$2=nursetb!$A$1:$A$1354)*(ytd !$A6=nursetb!$B$1:$B$1354))=0,
"",yourindexformulahere)))
"petes_girl via OfficeKB.com" wrote:
I have the following formula:
{=INDEX(nursetb!$D$1:$D$1354,MATCH(1,(ytd!C$2=nurs etb!$A$1:$A$1354)*(ytd!
$A6=nursetb!$B$1:$B$1354),0))}
Which works great, but if there is no information to match etc it returns a
#n/a any chance I can get this to return a blank somehow.
Many thanks in advance
Petes girl
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1
--
Dave Peterson