LinkBack URL
About LinkBacks
Hi I have the following formula for a named range, I need to incorporate the title UseList (relates to a flexible data range) into it, any ideas?
=INDIRECT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($H$16," ","_"),"&","_"),"""","_"))
Cheers
JD
Hi I have the following formula for a named range, I need to incorporate the title UseList (relates to a flexible data range) into it, any ideas?
=INDIRECT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($H$16," ","_"),"&","_"),"""","_"))
Cheers
JD
Hi,
"Incorporate" where? In what way? What should the result be? How does this relate to your previous post?
Please try and provide as much information as possible in your initial posts so that we can help you.
Regards
Your current formula replacing the Space, & symbol and " Single quote with Underscore character.
After that redirecting it to the named range with the use of Indirect.
What modification you are looking to do with it? Please describe it in detail
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
This data validation formula relates to the first drop down list in H16, the result of that lists selection needs to lookup up UseList, however due to the nature of the titles in the H16 dropdown list the spaces and the & symbols need to be taken into consideration.
Hope that helps to explain.
JD
Please let us know the text value of H16 Cell
The Variants are user entered and can incorporate any text, numerics and the & symbol -
AAP
Attention To Detail
Confidence & Communication
Drop In 1 to 1 Additional Support
Ease Tension
Fight Your Fears
Identify Transferrable Skills & Personal Profile Creation
IT Work Related Activity
Personal Excellence & Prepartion For Interview
Stress Relief & Relaxation
Working With Others & "Next Step" Progression Plan
Cheers
JD
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks