#1
|
|||
|
|||
INDIRECT Function not working
Hi there, should be so easy, but I can't get it working: I'm using this Formula to get a "1" Value when FIND a "-" symbol in a Cell two columns to the right. Code:
=FIND("-",(INDIRECT("RC2",FALSE))) Thank you |
#2
|
|||
|
|||
Found it by myself. It hast to be:
Code:
=FIND("-",(INDIRECT("RC[2]",FALSE))) |
#3
|
||||
|
||||
Hi and thank you for sharing the solution
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
Thank you ! That's it.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Indirect function error referencing worksheets | wuddog | Excel | 1 | 03-24-2017 10:55 AM |
Indirect not working in Conditional Formatting | tinfanide | Excel | 11 | 06-21-2016 04:55 PM |
Confusion on INDIRECT function | thatgirlaudrey | Excel | 4 | 06-06-2014 09:23 PM |
Data validation using indirect function | BullMouse | Excel | 2 | 11-30-2011 05:25 PM |
Can't get AND function working | Scaffold | Excel | 6 | 07-09-2010 01:41 AM |