index match mutliple criteria

Want to say if column B "Type" is equal to column E "Type", and Column C "Name" is equal to column D "Name", then put the value of column K, in column A.

I have simplified this as much as I can. check out the attachment...

so i thought

Please Login or Register  to view this content.

I am pulling a lot of #Ref errors not sure why?

Try this formula in A3 copied down

=IF(LEN(B3&C3),LOOKUP(2,1/(B3=E$3:E$35)/(C3=D$3:D$35),$K$3:$K$35),"")

thanks once again it works