Look up range

[Jim]

I am trying to create a spreadsheet where I need to look up and a IF maybe?
Here is the situation. I need it to search a column G1 through G10 for min
diameters and H1 through H10 for max diameters. In this scenario A1 needs to
find a clamp. The clamp numbers are located in E column with the min range of
each clamp in G1 and the max clamp range in H column.

A1 = 1.437

Part number (E1) G1 H1
-282 1.000 1.250
-310 1.251 1.500
-335 1.501 1.750

In this example how do I get a function to return that A1 requires a -310 P/N

Thanks
Jim

 

[Tom Ogilvy]

Put 1.751 in G4 and you can use

=INDEX($E$1:$E$3,MATCH(A1,$F$1:$F$3,1),1)

 

[RagDyeR]

Tom had a small typo.

You could try this:

=INDEX(E1:E3,MATCH(A1,G1:G3,1))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Put 1.751 in G4 and you can use

=INDEX($E$1:$E$3,MATCH(A1,$F$1:$F$3,1),1)

 

[Tom Ogilvy]

I guess when i pasted the data, it went in F, didn't notice. Thanks for the
correction.