| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Condition for worksheet reference
This is the function I currently have:
=IF(L2<"",INDIRECT("'"&L2&"'!B"&ROW($A$2)),"") I want to modify it in the following way.... =IF(L2<"", {IF STATEMENT} INDIRECT("'"&L2&"'!B"&ROW($A$2)),"") I want to add another if statement where shown above to check if there is a sheet called '"&L2&'"! . So basically IF('"&L2&'"! EXISTS, TRUE, FALSE) Thanks in advance for any help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| deleting rows in a worksheet if condition is met | Excel Discussion (Misc queries) | |||
| copy row content from one worksheet to another, if a condition met | Excel Worksheet Functions | |||
| copy data from 1 worksheet to another based on a condition | Excel Worksheet Functions | |||
| External reference as a condition | Excel Worksheet Functions | |||
| External reference as a condition | Excel Worksheet Functions | |||
Threaded Mode
