I need a formula to look at a value in one column and look for it in another
column, in the same row. The second cell will have other various data in
it.the formula would appear in a 3rd column here's an example.

A B
C
8752 Irr Ltr fxd 3609 4/18/06 CAdrian, 8752 3/24/06
2611 Irr Ltr Fx 6091, 10418,7362,2734,9187 3/20/06
8316 Irr ltr fxd 8283 02/24/05 VOrtega,5466

Assuming 8752 is in A1 and "Irr Ltd fxd 3609..." is in B2 you can enter this
formula in C1 to look up 8752:

=SEARCH(A1,B1)

If the text is found, the function returns the number of the character where
the text is first found. If it is not, a #VALUE! error message is displayed.

SEARCH is not case sensitive. Here it only looks for numbers, so it doesn't
matter, but if you need to do a case sensitive search, use FIND instead.

If this is not what you are looking for, please explain further.

--
Kristoffer Andreas Berg
Programmer on a hobby basis
http://home.online.no/~gunnarab


"Hakojin" wrote:

I need a formula to look at a value in one column and look for it in another
column, in the same row. The second cell will have other various data in
it.the formula would appear in a 3rd column here's an example.

A B
C
8752 Irr Ltr fxd 3609 4/18/06 CAdrian, 8752 3/24/06
2611 Irr Ltr Fx 6091, 10418,7362,2734,9187 3/20/06
8316 Irr ltr fxd 8283 02/24/05 VOrtega,5466

thank you very much, worked perfect. I was trying much more complicated
formulas and it was so simple.

"Kristoffer Andreas Berg" wrote:

Assuming 8752 is in A1 and "Irr Ltd fxd 3609..." is in B2 you can enter this
formula in C1 to look up 8752:

=SEARCH(A1,B1)

If the text is found, the function returns the number of the character where
the text is first found. If it is not, a #VALUE! error message is displayed.

SEARCH is not case sensitive. Here it only looks for numbers, so it doesn't
matter, but if you need to do a case sensitive search, use FIND instead.

If this is not what you are looking for, please explain further.

--
Kristoffer Andreas Berg
Programmer on a hobby basis
http://home.online.no/~gunnarab


"Hakojin" wrote:

I need a formula to look at a value in one column and look for it in another
column, in the same row. The second cell will have other various data in
it.the formula would appear in a 3rd column here's an example.

A B
C
8752 Irr Ltr fxd 3609 4/18/06 CAdrian, 8752 3/24/06
2611 Irr Ltr Fx 6091, 10418,7362,2734,9187 3/20/06
8316 Irr ltr fxd 8283 02/24/05 VOrtega,5466

One more thing to say is that if you find the error message disturbing, you
can enter this formula in D1:

=IF(ISERROR(C1),"Not Found","Found")

and format C1 with white font color.

--
Kristoffer Andreas Berg
Programmer on a hobby basis
http://home.online.no/~gunnarab


"Hakojin" wrote:

thank you very much, worked perfect. I was trying much more complicated
formulas and it was so simple.

"Kristoffer Andreas Berg" wrote:

Assuming 8752 is in A1 and "Irr Ltd fxd 3609..." is in B2 you can enter this
formula in C1 to look up 8752:

=SEARCH(A1,B1)

If the text is found, the function returns the number of the character where
the text is first found. If it is not, a #VALUE! error message is displayed.