Hard to say what's causing that result.
You could always use a helper column.
Enter this formula in G34 and copy down to G86:
=IF(AND(C34>=I$10,E34>=I$10),1,"")
Then the lookup formula would be:
=INDEX(A34:A86,MATCH(2,G34:G86))
Hard to say what's causing that result.
You could always use a helper column.
Enter this formula in G34 and copy down to G86:
=IF(AND(C34>=I$10,E34>=I$10),1,"")
Then the lookup formula would be:
=INDEX(A34:A86,MATCH(2,G34:G86))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks