Hello, I need to write a search formula that will search for text in several columns and then return a value in a separate cell. The value returned will be taken from the cell to the left of where the text is discovered. If I use the following table as an example I want to report the price of...