Hi GS,

I have a semi-working solution based on the following:

=OFFSET(Brand,MATCH($C2,Manufacturer,0)-1,0,COUNTIF(Manufacturer,$C2))

With the Manufacturer / Brand lists the entries may not be sorted. I can do this manually of course, however I am wondering if there is a way to handle the lists in an unsorted way. The same two columns apply, Manufacturers (Make) in one column, and Brand (Model) in the adjacent column. If Manufacturer A has an entry interspersed with Manufacturer B, or Manufacturer C what I am receiving back in the Brand (Model) validation list is the correct number of entries, but the entries are from a contiguous set of cells in the Brand (Model) column rather than the scattered individual entries relevant to the Manufacturer.

I think this can be solved with an array formula but I am unsure how to proceed with this. Do you have any ideas?

Cheers

The Frog