I cannot figure this one out maybe someone can help. I need to return a
value based on two previous knowns.

In B2 I have a list and can choose either 5, or 15
And then in B3 I can choose from a variety of sizes 1, 8, 6, 14 (sizes
are common for 5, or 15)
In B4 I want it to go to sheet two in the size column and find the
appropriate and then go to the appropriate 5, or 15 column and return
the data than corresponds with that.

Example
B2 – 5
B3 – 8
B4 – looks in sheet two size column and finds the 8 and then in the
weight column for 5 and finds 0.233 and returns that result.

Or

B2 – 15
B3 – 6
B4 - looks in sheet two size column and finds the 6 and then in the
weight column for 15 and finds 0.355 and returns that result.

Any help is appreciated. Thanks.

Mike


--
MIKE0W
------------------------------------------------------------------------
MIKE0W's Profile: http://www.excelforum.com/member.php...o&userid=21465
View this thread: http://www.excelforum.com/showthread...hreadid=378957