LinkBack URL
About LinkBacks
I have two cells.
Cell A2 has: "Davis, Jeffery B XX-13 ABCD 325 ERT/YUT" without the quotations.
Cell A3 has: "1, 2, 5, 11" without the quotations
I want A4 to to say Yes, if that 325 in Cell A2 is in Cell A3 or No if it isn't.
Check if an exact number in a sentance in a cell is in a cell with multiple possible nbrs
I have two cells.
Cell A2 has: "Davis, Jeffery B XX-13 ABCD 325 ERT/YUT" without the quotations.
Cell A3 has: "1, 2, 5, 11" without the quotations
I want A4 to to say Yes, if that 325 in Cell A2 is in Cell A3 or No if it isn't.
Last edited by Article92; 09-21-2022 at 10:40 PM.
Can the number always be found in a predictable place in the string? And how many digits can the number consist of?
And do you still need an answer to this question, if this similar question is solved?
See https://www.excelforum.com/excel-for...ml#post5730008
I tried to make a formula, but you should add a cell on your data to identify the number.
The Expert should have the simple formula for this problem.
Try this formula in A4 as an array formula (Control + shift + enter)
Please Login or Register to view this content.
Happy with my advice? Click on the * reputation button below
For Excel 2016 users, I cannot further simplify your formula for identifying a number.
This is possible for users Excel 365/2021. Please try:Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks