aequitas1903
Board Regular
- Joined
- Mar 8, 2012
- Messages
- 127
Hello Everyone,
I do have a data in which column A has lots of information in one cell. and column B has numeric information. I do want to search values in column B in column A. I need a formula in column C to show me the adress of the found data. There is an example below.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]ColumnA[/TD]
[TD]ColumnB[/TD]
[TD]ColumnC[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Ben2123.52.921.30.09.2013[/TD]
[TD]5753[/TD]
[TD]A3[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John53234.12.534.01.08.2014[/TD]
[TD]921[/TD]
[TD]A1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Harry5753.54.524.23.04.2013[/TD]
[TD]535[/TD]
[TD]Not Found[/TD]
[/TR]
</tbody>[/TABLE]
Please let me know if it is possible to write a formula like this. Any help is appreciated.
I do have a data in which column A has lots of information in one cell. and column B has numeric information. I do want to search values in column B in column A. I need a formula in column C to show me the adress of the found data. There is an example below.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]ColumnA[/TD]
[TD]ColumnB[/TD]
[TD]ColumnC[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Ben2123.52.921.30.09.2013[/TD]
[TD]5753[/TD]
[TD]A3[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John53234.12.534.01.08.2014[/TD]
[TD]921[/TD]
[TD]A1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Harry5753.54.524.23.04.2013[/TD]
[TD]535[/TD]
[TD]Not Found[/TD]
[/TR]
</tbody>[/TABLE]
Please let me know if it is possible to write a formula like this. Any help is appreciated.