Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-07-2017, 02:35 AM
Liquid77 Liquid77 is offline Windows 10 Office 2016
Novice
 
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 Windows 10 Office 2016
Novice
 
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 Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,901
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

Hi and thank you for sharing the solution
Reply With Quote
  #4  
Old 10-08-2017, 01:30 AM
Liquid77 Liquid77 is offline Windows 10 Office 2016
Novice
 
Join Date: Oct 2017
Posts: 3
Liquid77 is on a distinguished road
Default

Thank you ! That's it.
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

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


All times are GMT -7. The time now is 03:01 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft