Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to find value from one column in another column of the same r
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to find value from one column in another column of the same r
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to find value from one column in another column of the sa
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to find value from one column in another column of the sa
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Find Numeric Criterion in Column & Return the Numeric Value from Row above | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) |