I'm trying to write a formula using OFFSET & MATCH to fill in another cell.
What I want to do is OFFSET I19, MATCH I8&BM1 to cells I19:I445&AK19:AK445
but if the adjacent cell in column BC says "Yes" don't use it and skip to the
next match (there will be another cell that matches without Yes). I came up
with this formula but it doesn't work, the result is blank.

Quoted = BC1:BC445
Array Entered:
=IF(ISNA(OFFSET($I$19,MATCH($I8&BM$1,$I$19:$I$445& $AK$19:$AK$445&Quoted<"Yes",0)-1,18,-1,-1)),0,OFFSET($I$19,MATCH($I8&BM$1,$I$19:$I$445&$AK $19:$AK$445&Quoted<"Yes",0)-1,18,-1,-1))

If I take out the Quoted<"Yes" it finds the first match but sometimes cell
BCxx says Yes and that's the wrong result.

I hope I wasn't too confussing.
Thanks for your help
Joe