I did have this working and now it's stopped
=IF(SUMPRODUCT(--(COUNTIF(INDIRECT("'"&WsLst&"'!H3:H34"),S3)0)),IN DEX(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