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 value in ($P$294) would be in cell ($Q$309).
The search range could vary quite a bit
Column L Column M Column N Column O Column P
1 4 MSQ Lot end 2W1703 04/01 04/01/18 18:22:00 Row 294
04/01 04/01/18 18:22:04 Row 295
04/01 04/01/18 18:22:04 Row 296
04/01 04/01/18 18:22:04 Row 297
04/01 04/01/18 18:22:04 Row 298
04/01 04/01/18 18:22:04 Row 299
04/01 04/01/18 18:22:04 Row 300
04/01 04/01/18 18:22:04 Row 301
04/01 04/01/18 18:22:04 Row 302
04/01 04/01/18 18:22:04 Row 303
04/01 04/01/18 18:22:04 Row 304
04/01 04/01/18 18:22:04 Row 305
04/01 04/01/18 18:22:04 Row 306
04/01 04/01/18 18:22:04 Row 307
04/01 04/01/18 18:22:04 Row 308
1 4 MSQ Lot end 2W1703 04/01 04/01/18 18:22:04 Row 309
So in this example it would be formula: =Search above until ($L$309) has been found, once it has been found ($L$294) the value in ($P$294) would be in cell ($Q$309).
The search range could vary quite a bit
Column L Column M Column N Column O Column P
1 4 MSQ Lot end 2W1703 04/01 04/01/18 18:22:00 Row 294
04/01 04/01/18 18:22:04 Row 295
04/01 04/01/18 18:22:04 Row 296
04/01 04/01/18 18:22:04 Row 297
04/01 04/01/18 18:22:04 Row 298
04/01 04/01/18 18:22:04 Row 299
04/01 04/01/18 18:22:04 Row 300
04/01 04/01/18 18:22:04 Row 301
04/01 04/01/18 18:22:04 Row 302
04/01 04/01/18 18:22:04 Row 303
04/01 04/01/18 18:22:04 Row 304
04/01 04/01/18 18:22:04 Row 305
04/01 04/01/18 18:22:04 Row 306
04/01 04/01/18 18:22:04 Row 307
04/01 04/01/18 18:22:04 Row 308
1 4 MSQ Lot end 2W1703 04/01 04/01/18 18:22:04 Row 309