Thanks Max,
First I did that to the wrong file. I made the change to the previous one,
and now it works GREAT.


"Max" wrote:

Just a guess, Serge,
try changing FALSE to TRUE for the 4th param in the VLOOKUP

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Serge" wrote in message
...


"Serge" wrote:

The formula shown below was working fine.
But as you can see for example between 0.75 & 0.8125 there are possible
input that will give an error message.
=VLOOKUP(I9, INDIRECT(VLOOKUP(D9, $P$1:$Q$9,2)),2,FALSE)
Current table below:
".500 Dia. Bolt
GRIP INCHES" Length (inches)
0.7500 1.50
0.8125 1.50
0.8750 1.75
0.9375 1.75
1.0000 1.75
1.0625 1.75
1.1250 2.00
1.1875 2.00
1.2500 2.00
1.3125 2.00
1.3750 2.25
1.4375 2.25
1.5000 2.25
1.5625 2.25
Until I tried to modify the table to cover ranges that the first table
did
not have.
now I get #N/A
New table below:
".500 Dia. Bolt
GRIP INCHES Length (inches)
=0.750 1.50
<0.875 1.50
=0.875 1.75
<1.125 1.75
=1.125 2.00
<1.375 2.00
=1.375 2.25 (made correction)
<1.625 2.25
=1.625 2.50
<1.875 2.50
=1.875 2.75
<2.125 2.75
=2.125 3.00
<2.375 3.00

Can someone help with my problem please.
Many thanks in advance