INDIRECT Function not working

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 03:34 PM.