![]() |
Referring to sheets in formulas
Hi,
I have the following formula set up which refers to one other sheet: =IF(ISERROR(SMALL(IF(('MANAGEMENT POLICIES & ADMIN'!$E$10:$E$128="Yes"),ROW($C$1:$C$119)),ROW()-ROW($C$1))),"",INDEX('MANAGEMENT POLICIES & ADMIN'!B$10:B$128,SMALL(IF(('MANAGEMENT POLICIES & ADMIN'!$E$10:$E$128="Yes"),ROW($C$1:$C$119)),ROW()-ROW($C$1)))) How can I add to the 'MANAGEMENT POLICIES & ADMIN'! part of the formula to work for sheets 2,3 and 4 too. |
All times are GMT +1. The time now is 12:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com