I have an excel 2010 formula question.
I am trying to get the first column value for a vlookup with a range.

Here is what I have
cell A1 = ID

ID comp MIN MAX
01 aaaa 001 010
02 aaaa 011 100
03 aaaa 100 200
04 bbbb 001 200
05 cccc 001 050
06 cccc 051 500

cell D7=500


CELL K1 = aaaa
CELL K2 = 12

I need to match K1 to the "comp" (B) column.
The I have to see get the ID of the row that K2 is between.

So the result of this example would be 02

CELL K1 = bbbb
CELL K2 = 200

would = 04


CELL K1 = cccc
CELL K2 = 050

would = 05

I can not seem to get the array formula down..

Suggestions (and yes I know to press ctrl-shift)

Thanks..