I know I asked this same type of question yesterday but for some reason
I cannont get it to work. Here is my problem:

B2 – has a list to choose from either 5kv, 15kv, 25kv, …
B3 – has a list also to choose from 8, 10, 12, 500
B4 – here is my problem:
I need B4 to look up B2 and match the size to sheet2 column B
Then take the value in B3 match it with the value in sheet2 column D
And input the number located in column F in that same row across.
I am pretty sure this can be done but I am having a hard time trying to
index and match where I need to find two values from two comumns.
Thanks for the help..


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