Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-07-2017, 02:35 AM
Liquid77 Liquid77 is offline INDIRECT Function not working Windows 10 INDIRECT Function not working Office 2016
Novice
INDIRECT Function not working
 
Join Date: Oct 2017
Posts: 3
Liquid77 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 10-07-2017, 03:14 AM
Liquid77 Liquid77 is offline INDIRECT Function not working Windows 10 INDIRECT Function not working Office 2016
Novice
INDIRECT Function not working
 
Join Date: Oct 2017
Posts: 3
Liquid77 is on a distinguished road
Default

Found it by myself. It hast to be:

Code:
=FIND("-",(INDIRECT("RC[2]",FALSE)))
Reply With Quote
  #3  
Old 10-07-2017, 07:17 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline INDIRECT Function not working Windows 7 64bit INDIRECT Function not working Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #4  
Old 10-08-2017, 01:30 AM
Liquid77 Liquid77 is offline INDIRECT Function not working Windows 10 INDIRECT Function not working Office 2016
Novice
INDIRECT Function not working
 
Join Date: Oct 2017
Posts: 3
Liquid77 is on a distinguished road
Default

Thank you ! That's it.
Reply With Quote
Reply

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 Function not working 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
INDIRECT Function not working Data validation using indirect function BullMouse Excel 2 11-30-2011 05:25 PM
INDIRECT Function not working 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:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft