Finding Minimum Value, Then locate Value to Immediate left of Cell where Minimum was Found

Thanks for the reply, the problem is that my data is not contiguous; implying arrays cannot be used. Here is an actual example of the function I am using to get my initial minimum value:
SMALL((AN5, AP5, AR5, AV5), FREQUENCY((AN5,AP5,AR5,AV5),{0})+1). Once this minimum value is determine from these set of cells (AN5, AP5, AR5, AV5), I would then like to get the value in the cell on the same row immediately to the left of where the minimum value was found.
Thanks.

Please see the attached sample spreadsheet. The SMALL/FREQUENCY function is in L2. Think that columns are grouped in two’s. For this test, I compared columns D, F, H. Note, F2 is why MIN could not work. I used SMALL/FREQUENCY (in L2) to find the smallest value (H2) of this set. Since H2 is the smallest numeric from this test, I want to reference the value of H2 (done) but most important, I want to reference the adjacent value in G2. If D2 was the smallest value, I would need the value of D2 and C2 etc. The real data has about fifteen columns paired and I am not searching all the columns in any one instance, I am only searching a select group of columns and the group of columns are not immediately adjacent which is why arrays could not be used.

Thanks.

Biff,

Thanks for the reply. The INDEX function will not work since my data is disjointed and not continuous across columns (arrays). In the attached spreadsheet, I am comparing data from columns D2, F2, H2 to determine the minimum of these three values. Note F2 value is xxxx (not numeric therefore, MIN could not work). So with the SMALL/FREQUENCY, the minimum of D2, F2 and H2 is found in H2, which is correct, and then what I am also looking for is the value in the column before H2 which is the value in G2. I do not know how to get this value. Remember my real spreadsheet has about fifteen paired columns so I will be applying SMALL/FREQUENCY to any subset of these columns. I will select the minimum and the value at the offset one column to the left of the minimum value. Please see attached.

Thanks.