Formula using IF ISNUMBER and SEARCH functions

Hello there,   Is it possible to look (or search) for specific text in a column (Column A), and if that text is found, take the number that is in Column B (same row) and place it in Column C. If th...