Formula error

C

Chris

I did have this working and now it's stoppe
=IF(SUMPRODUCT(--(COUNTIF(INDIRECT("'"&WsLst&"'!H3:H34"),S3)>0)),INDEX(WsLst,MATCH(TRUE,COUNTIF(INDIRECT("'"&WsLst&"'!h3:h34"),S3)>0,0)),"Not Found")

WsLst is a named range P1... P12
H3:H34 is the range I'm looking in
S3 is the cell which value I'm trying to find inthe range H3:H34 on
worksheets P1:p12
The formula did return either P1, P2 etc Where P1.. P12 are the names of the
worksheets. I'm baffled. The only difference is that I have locked out some
cells

Help, most frustrating

Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif formula perhaps 8
Indirect Use of XLM in Excel 2000 and Prior 11
Indirect function help please 10
Weighted Average across worksheets 5
Mac Excel 2011 and MS Excel 2007 #N/A 0
Excel Formulas (Insert Define Name) 6
Vlookup and return sheet name also 2
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1

Top