Return value based on criteria

A

andiam24

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(ALTable),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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select minimum with duplicate values to return column headings 3
Query criteria based on a changing criteria list 2
Match Multiple Criteria and Return values positioned above the zero 6
Can you use an INDEX array in a COUNTIF formula ? 1
return multiple values when within range (greater than and less than) 11
Summing cells based on mulitiple criteria over mulitple columns 1
Return value with 2 conditions (using Lookup/Match/Index) 3
SUMIF with OFFSET 5

Top