hello experts. I'm trying to use the index(match) function to populate the cells in column Y ("Put BID") with the values from column L ("BID") that match the , but only if the option type is "Put" (=column F="p"). the problem is the file is organized in a Call row and a Put row (alternately). I need the formula to first identify if this row is for put or calls (F="p"). Also, the initial test is column W ("new minute?")="yes". if false then the cell in Y is irrelevant and should stay blank or "".

so here's what I'm thinking (and of course isn't working): for the first row, to populate Y2 the tests are:
1. First we test if this record (row) is a new minute or a continuation of the current minute quote: =if(W2="yes",round(O2,0)) - this is working fine.
2. Now I'm trying to make the formula find the L value in the row where F=X2 (17 in this case). =if(isnumber($X$2),index(L:L,match(X2,E:E,0)),"")


Attached is the spreadsheet sample..
livol kevin -forum.xlsx

P.S. for some reason I cannot isolate the time from column B using the =right(B2,4) function.. i get weird, informatable values