offset match with multiple criteria

[WelshBL]

hiyas all,
Ive looked around the searches and cant seem to find anything that does what I am looking for
basically I have a cell with model of car i.e. focus and a cell which recognises if standard metallic or dualtone paint is selected with a 1 2 or 3 number produced from formula

the table I have is roughly
model - type - colour
focus - 1 - red
focus - 1 - white
focus - 1 - black
focus - 2 - red

and so on

I can get the combobox in a userform to read a singlular column and display the colour with
=OFFSET(ColourStart,MATCH(location of model,ColourModel,0)-1,2,COUNTIF(ColourModel,location of model),1)

but I want to get it to read
the model and type so it only displays the list of colours for either standard (1) metallic(2) or dual tone (3)

I have tried to change formula to a variation on the match
=OFFSET(ColourStart,MATCH(1,(ColourModel=location of model)*(ColourType=Location of paint type),0)-1,2,COUNTIF(ColourModel,location of model),1)

but just keep getting an error

can anyone point me in the right direction?

Thanks guys n gals

 

[AhoyNC]

Maybe something like this?
The formula in F5 is an array formula and must be entered with CTRL-SHIFT-ENTER.
Drag formula down as needed.

Excel Workbook
	A	B	C	D	E	F
1	model	type	colour		Model	focus
2	focus	1	red		type	1
3	focus	1	white
4	focus	1	black		# of Colors	3
5	focus	2	red		colors	red
6						white
7						black
8
Sheet

 

[WelshBL]

the formula needs to be in a combobox in a userform so it will only list the drop down of the colours available for that specific one
i cant test at the moment as not at my work pc but would that formula work as rowsource in that combobox?

 

[WelshBL]

this didnt work in a row source of the combobox im still back to square one, can anyone give me an idea on what i may be looking for using the =offset Match for 2 vertical criteria