Here's a link to a sample file with an implemented construct
http://www.savefile.com/files/7767107
File: VLOOKUPwithIFstatement_Kay_misc.xls

And some clarifications:
(Ensure GN1:GN4 are left empty)

Pl disregard the above refrain. It's not applicable here, sorry, since
we're not using entire col references within the SMALL(...) part in the
extract formulas.

In the sample file provided, the results of the query are now extracted
directly into Sheet1's A5:A87, just below the inputs in A2:A3, instead of
into another Sheet2 as posted earlier. The same extract formula is placed
into the starting cell A5, then copied down to A87. Makes for a better
presentation for user to see the query results ! <g
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--