May 15 2019 05:03 AM
This may be a basic question, but I have been looking for the way to find an answer for this over the past few days.
Suppose sheet 1, ColumnA:
123
456
789
Then I have another sheet2, columnA
1724141
3415123
5123456
3123451
5123789
Is there a way for me to populate in columnB from sheet2 if the substring is found? my expectation is
columnA columnB
123 3415123 (columnB contains '123')
456 5123456 (columnB contains '456')
789 5123789 (columnB contains '789')
Thanks
May 15 2019 05:39 AM
@hnandarusdy , substring 123 in all of
3415123
5123456
3123451
5123789
You'd like to compare only last characters, or return first found or what?
May 15 2019 06:06 AM
May 15 2019 06:15 AM
@Twifoo , the only point the formula shall return result into column B of Sheet1 from A:A in Sheet2.
May 15 2019 06:42 AM
May 15 2019 06:45 AM
Solution@Twifoo , at least that's my understanding of the question. In this its' part.
May 15 2019 03:49 PM
May 15 2019 04:13 PM
Thanks.
This is absolutely the answer. One thing though, the cell must be in "text" format.
edit: I have mistakenly pressed the button of "best response" to @Sergei Baklan and I don't know how to change it :(
May 15 2019 08:51 PM
May 15 2019 06:45 AM
Solution@Twifoo , at least that's my understanding of the question. In this its' part.