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