Thread: search multiple worksheets for an item and return the Wsheets name
View Single Post
  #4   Report Post  
Frank Kabel
 
Posts: n/a
Default
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

Reply With QuoteReply With Quote