INDIRECT Function not working

		Microsoft Office Forums > Microsoft Excel > Excel
INDIRECT Function not working

FAQ

Thread Tools

Display Modes

10-07-2017, 02:35 AM

Liquid77

Windows 10 INDIRECT Function not working

Office 2016

Novice

Join Date: Oct 2017

Posts: 3

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

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

Thank you

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:29 PM.