ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula error (https://www.excelbanter.com/excel-worksheet-functions/6586-formula-error.html)

Chris

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