Adding greater than and less than to my search

[localhero]

Excel Help.JPG
Let me describe what I'm doing and where my hangup is.
I have a pin that goes on the end of a wire. I can type my pin # (yellow squares) and the gauge (AWG) of my wire (yellow squares) to get my Applicator (T-8302B in this example).

The red box displays the applicator for the pin # and AWG entered. The code for the red box is typed below the red box. It has parenthesis.

As you can see, pin 08-0151 has 2 applicators depending on the insulation outside diameter (OD). I have made columns for the range that the applicator will support.

What do I have to add to the code to search for a number entered into the Insulation OD box to return the correct applicator? 0.055 for example.

Thanks for any help or guidance.

[bebo021999]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[avk]

Try it now, dear localhero, Your formula right, you need to after type formula : Shift+Ctrl+Enter

[localhero]

The image was attached because I cannot seem to attach a file. The paperclip icon is blank when I click it.

My code works for getting the applicator based on the Pin and AWG inputs, my problem is that I need a way to choose between the 08-0151 pins.
How can I type a number in the Insulation OD (Yellow Box) and have it check that my OD falls in between the numbers in columns F & G?

The code inside the red box is {=INDEX(C2:C5,MATCH(B8&E8,A2:A5&D2:D5,0))}

How do I add a search for a number range to this code?

[cbatrody]

Modify the formula as following:

=INDEX($C$2:$C$5,MATCH(1,($A$2:$A$5=B8)*($D$2:$D$5=E8)*($F$2:$F$5<=G8)*($G$2:$G$5>=G8),0))

array entered - to be confirmed by pressing CTRL+SHIFT+ENTER

This is assuming you have the "Insulation OD" criteria in G8

[localhero]

YESSSSSSS!!!!!!!!
Thanks you. That did it.