| Home |
| Search |
| Today's Posts |
|
#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. |
| 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) | |||
Threaded Mode
