![]() |
Formula error
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 |
All times are GMT +1. The time now is 02:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com