Here's another option which uses index/match/offset to deliver the goods ...

Illustrated in this sample:
http://www.freefilehosting.net/download/3k2jd
Extract from table based on 3 input params.xls

Assuming source reference table in A10:E24,
with the text "Dealer" placed into A11 (instead of in A10)
(this makes the table's structure symmetric & easier to read from)

Then in say, D6:
=IF(COUNTA(D2:D4)<3,"",
INDEX(OFFSET(A11:A24,,MATCH(D3,A10:E10,0)-1),
MATCH(D2,A10:A24,0)+MATCH(D4,OFFSET(A10,MATCH(D2,A 10:A24,0)-1,1,7),0)-2))
will return the result from the reference table
based on input DV selections made in D2:D4
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik
---