Vlookup (and/or) IF funtion

I don't exaclty know the best funtion to use for the following:

In sheet one, I have a bolt diameter in 'D9' and a grip length in 'I9'. In
'J9' should be the result 'bolt lenth' comming from nine different tables of
bolt diameters and grip length on sheet three.
Would someone be willing to look at what I have done so far and guide me to
the correct approach for getting the corresponding length for the given bolt
diameter and grip length.
Thanks in advance,
Serge
[email protected]

Well, I wouldn't mind helping if I can if I could get a look at your
spreadsheet; this sounds similar to a scenario I worked on in a different
context. Send a copy to [email protected]

I'm presently on holioday so will not be able to have a good look at it
until 28 Feb if that is OK

"Serge" wrote:

> I don't exaclty know the best funtion to use for the following:
>
> In sheet one, I have a bolt diameter in 'D9' and a grip length in 'I9'. In
> 'J9' should be the result 'bolt lenth' comming from nine different tables of
> bolt diameters and grip length on sheet three.
> Would someone be willing to look at what I have done so far and guide me to
> the correct approach for getting the corresponding length for the given bolt
> diameter and grip length.
> Thanks in advance,
> Serge
> [email protected]