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

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

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