need to find value from one column in another column of the same r

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
thank you very much, worked perfect. I was trying much more complicated
formulas and it was so simple.
 
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.
 
Back
Top