Ask a new question

How to use named range in Search function?

I am trying to use named range in search function

Named Range 'words' contains- 28 values, When the named range 'words' is used in the Search formula and the formula is dragged the search functions checks the first value (for first cell), second value (for second value), third value (for third value) and so on..., in the range and compares with the within_text and returns the number instead of comparing the whole named range each time.

Hello,

We would like to know more about your concern. Kindly answer the questions below:

  • Kindly send us the formula that you're currently using.
  • Kindly explain what you want to do with the formula and what outcome or result you want to get?
  • The "Search" function will only give you the position of the text from the set of strings. You may visit this link for more information.

We look forward to your response.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated February 7, 2024 Views 406 Applies to: