Is there a search formula that could take value ($L$309) '1 4 MSQ Lot end' and have it search above until it finds the same value in Column L and display Column P value?
So in this example it would be formula: =Search above until ($L$309) has been found, once it has been found ($L$294) the...