INDEX / MATCH Formula

[biggsy3]

Hi All,

I'm looking for a bit of help on a formula.

This is the formula I'm currently using;

=IFERROR(IF(INDEX($B$26:$B$54,MATCH(B1,$A$26:$A$54,0))="","",INDEX($B$26:$B$54,MATCH(B1,$A$26:$A$54,0))),"")

This Index/Match formula works great if the data pasted in, is in the correct order.

However if the data gets pasted in a different order, or less data is pasted in it doesn't work.

I need help with some sort of 3 Dimensional lookup.

Here is an example of what I'm trying to do;



So for example for B3 I need it to reference the paste data at the bottom by 3 criteria - 1st criteria Horizontal - 2nd criteria Corris Grey - 3rd criteria F-Type convertible.

Im not sure any of this will make sense, but I would appreciate any help.

 

[biggsy3]

Would a hlookup be an option?