Hi,

I'm actually facing such a similar problem by auslistener1. I want to create a dropdown list that is filtered based on 2 criterias.

My data has more than 60,000 rows covering 3 columns, so the example at the contextures.com wouldn't be helpful to me.

Worksheet2
Column A - filled with customer id
Column B - filled with items bought by each customer
Column C - filled with the corresponding prices for the item.

The list looks like this

BDR001  item 1   4.67
BDR001  item 9   5.93
JRY007  item 1   4.93
BDR001  item 1   4.33
Worksheet1

BDR001 item 1 <dropdown list contains 2 entries, 4.67 & 4.33>

The example file is in the link below.
http://www.mediafire.com/?953f79niv955q83

Thank you.