Sorry to be thick here
what's the WSLst, is this the named range of my worksheet names?
"Frank Kabel" wrote:
Hi Harlan
[...]
=IF(SUMPRODUCT(--(COUNTIF(INDIRECT("'"&WSLst&"'!K5:K20"),Q5)0)),
INDEX(WSLst,MATCH(TRUE,COUNTIF(INDIRECT("'"&WSLst& "'!K5:K20"),Q5)0,0))
,
"Not found")
Nice and you're right. Should have thought about something like that
Frank
|