how to look up multiple multiple matching criteria and return single value

I am trying to figure out how to do a look up for values from a row on one sheet from columns a,b and c that will find the matching values columns a,b and c in in any row on another sheet . If all three values are found to be matching then I want a return value from column 9.

form Example Looking for this this is three separate columns: 255T1345-002 15 3


Any ideas?

Create a concatenation in a newly inserted column to the left of A (which will push everything to the right one column).

Post a sample data set.