Thread: Quote Matrix
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
blyr1020
 
Posts: n/a
Default Quote Matrix


That did the trick Bernie.
=INDEX(J17:Z44,MATCH(D4,G17:G44,False),MATCH(E4,J1 3:Z13,False))

As you noted I didn't need the extra column and row.

Thank you very much for your time.
Roger


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