Question description:
This user has given permission to use the problem statement for this
blog.
I have a column where each cell has letters and numbers. The numbers would range from 10 through 18. I would like to find a formula where I can search the cell for any one of the numbers and return a value from a different cell if it finds one.
I currently search for a specific number and the formula works but only for that particular number. The formula I currently have is: =IF(ISNUMBER(SEARCH("16",F10)),G10,"") This does work if it finds the value of 16 in the (F10)cell and then places the value from cell "G10" as the result. If it doesn't find the numbers, it will leave the resultant cell blank.
Solved by O. H. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
14/02/2018 - 03:13
Welcome, Thanks for choosing Got It Pro-Exc
Excelchat Expert
14/02/2018 - 03:14
How may I help you today?
Excelchat Expert
14/02/2018 - 03:14
What is the problem you are facing?
User
14/02/2018 - 03:15
I am trying to find a formula for the above scenario. Can I paste some info in the table?
Excelchat Expert
14/02/2018 - 03:15
of course
Excelchat Expert
14/02/2018 - 03:16
Is an Excel file available
User
14/02/2018 - 03:16
yes, but I cannot provide all the info in the document
Excelchat Expert
14/02/2018 - 03:17
Then go ahead and do it on the doc
User
14/02/2018 - 03:21
I would like to search for a range of numbers to include 14, 16 17 and the like
Excelchat Expert
14/02/2018 - 03:22
So, you would have a constant range of Numbers to search for?
User
14/02/2018 - 03:23
yes
Excelchat Expert
14/02/2018 - 03:23
OK allow me tho work on it.
Excelchat Expert
14/02/2018 - 03:31
The number are those three or the range is bigger
Excelchat Expert
14/02/2018 - 03:31
?
User
14/02/2018 - 03:32
These are graduation years, so currently they would be anywhere from 2010 (10) up to 2018 (18)
Excelchat Expert
14/02/2018 - 03:33
And the form of text in Column B varies?
Excelchat Expert
14/02/2018 - 03:34
I mean the No can be anywhere in the string?
User
14/02/2018 - 03:34
Form, no just content, unless you mean the order of items
User
14/02/2018 - 03:35
what if the number would be first?
Excelchat Expert
14/02/2018 - 03:35
I mean it's not always 16,N -
Excelchat Expert
14/02/2018 - 03:35
18,k
User
14/02/2018 - 03:35
correct but if it needs to be, it can
Excelchat Expert
14/02/2018 - 03:35
Yes
User
14/02/2018 - 03:35
I can make all of them to have the number first if that is what it takes
Excelchat Expert
14/02/2018 - 03:36
Maybe We could search in Column B to check if the two first characters are ISnumber and get the answer
User
14/02/2018 - 03:37
The data in the origianl document can be changed to make the number first. that shouldn't be a problem if that would help. we can also change it on the current document
User
14/02/2018 - 03:38
Shall I change them? or You?
Excelchat Expert
14/02/2018 - 03:38
OK Sir working on a sample excel file.
Excelchat Expert
14/02/2018 - 03:50
try this file Please
[Uploaded an Excel file]
User
14/02/2018 - 03:51
I believe this will work. Thank you so much
Excelchat Expert
14/02/2018 - 03:52
- Did that answer your question?
User
14/02/2018 - 03:52
I must go and set up for an event but would like to thank you very much for your help. this will work. Again thank you
Excelchat Expert
14/02/2018 - 03:52
Thanks for choosing us, if you need our help visit again.
Excelchat Expert
14/02/2018 - 03:53
Please give your kind feedback for our service
Excelchat Expert
14/02/2018 - 03:53
Have a good day ahead.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.