INDIRECT Function not working

Liquid77 · #1 10-07-2017, 02:35 AM

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)))

Can anyone tell me, why it's not working. It always shows #VALUE!

Thank you

Liquid77 · #2 10-07-2017, 03:14 AM

Found it by myself. It hast to be:

Code:

=FIND("-",(INDIRECT("RC[2]",FALSE)))

Pecoflyer · #3 10-07-2017, 07:17 AM

Hi and thank you for sharing the solution

Liquid77 · #4 10-08-2017, 01:30 AM

Thank you ! That's it.

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