Try setting the third parameter of each MATCH to False:

=INDEX(J17:Z44,MATCH(D4,G17:H43,False),MATCH(E4,J1 3:Z14,False))

BUT, and this one is important, you should only have one row or column as the range for the second
parameter of your MATCH functions.

=INDEX(J17:Z44,MATCH(D4,G17:G44,False),MATCH(E4,J1 3:Z13,False))

HTH,
Bernie
MS Excel MVP


"blyr1020" wrote in message
...

Sorry, my reply should have read.

I entered the following and the value returned #N/A

*=INDEX(J17:Z44,MATCH(D4,G17:H43),MATCH(E4,J1 3:Z14))*

not =INDEX(J17:Z44,MATCH(D4,G17:H43,FALSE),MATCH(E4,J1 3:Z14,FALSE))

The request was entered as Gauge = .031 and Width = 50 which should
return a line speed of 265. Any ideas of what I have wrong?

Roger


--
blyr1020
------------------------------------------------------------------------
blyr1020's Profile: http://www.excelforum.com/member.php...o&userid=31742
View this thread: http://www.excelforum.com/showthread...hreadid=514552