Macro to Select an Item from and array

[johnt3943]

I need a macro to select an item from an array based on an IS statement. The array is arranged in ascending order.


Col A Col B Col C Col D
5 1 A 1.1
10 2 C 1.5
15 3 D 2.0
20 6 F 4.0
25 9 H 6.0
30 2 K 7.0

Now my comparison number in a cell (say cell H5) is 21.2
I want to put 4.0 in cell H6.

I.e if H5 > A(x) Then H6 = D(x)

All help will be appreciated.

 

[mikerickson]

VLOOKUP should do this with a True final argument.

 

[johnt3943]

Thanks for the reply but the VLOOKUP with the TRUE argument only selects the closest Match.

I wanted any number greater that 20 and less than 25 to select the value 4.

I have figured it out with a VLOOKUP, with nested LARGE and COUNTIF functions

 

[mikerickson]

This worked for me
=VLOOKUP(H5, A1:D6, 4)