This formula works very nicely to return the specified occurrence (F91);
however, is there a way to modify it to return a value based on criteria?
Such as, if the value in say G90 is less than 0.2 or greater than 2.0 for the
first occurence then return the second occurrence?

=INDEX(ALTable,SMALL(IF(OFFSET(ALTable,0,0,ROWS(AL Table),1)=F90,
ROW(OFFSET(ALTable,0,0,ROWS(ALTable),1))-ROW(OFFSET(ALTable,0,0,1,1))+1,
ROW(OFFSET(ALTable,ROWS(ALTable)-1,0,1,1))+1),F91),2)

Thanks!