Excel - IF Function Problem - Expert Solution

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
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
User 14/02/2018 - 03:35
correct but if it needs to be, it can
Excelchat Expert 14/02/2018 - 03:35
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc