Excel 2007 : Multiple arguments in a table

[mcatjag5]

hi,

I was wondering if someone could help me.

I am trying to use multiple arguments to get a result, as follows.

If a pipe has a diameter of 20mm and the class of pipe is 150 then I need the formule to insert 1/2" UNC in the designated cell.. There are however 80 possible inputs, such as, 20mm, class 150 = 1/2" UNC, 50mm class 150 = 5/8" UNC, 150mm, class 1500 = 1 3/8" UN8, etc, etc.

I have created a table but am having huge dramas trying to get VLOOKUP to help!

Colin

[pike]

Hi mcatjag5
Welcome to the forum
can you attach a sample workbook?