Search 2 colums, display the value of a cell between the two results.

I have three colums of data.

Column A contains valuse like this : 44a, 44u, 44b, 44a, 44u etc..
Notice that some of the values repeat.

Column B contains values that represent length in feet: 12, 10, 8, 15, 17 etc..

Column C is similar to column A : 44u, 44c, 44u, 44b, 44s etc..
Again Notice that some of the values repeat.

I want to search for a value in col. A and Col C and if they equil what im searching for display the length.

Exampl: I enter the first location in cell d1, and the second location in cell d2
I would like to then search Col. A for the first loc. and Col. C for the second loc. and return the corrasponding length from col b.

I have tried the following code and connot get it to work correcly.


=IF( (MATCH(C11, A2:A6, 0)) = (MATCH(C12, C2:C6, 0) ), INDIRECT(CONCATENATE("B", (MATCH(C11, A2:A6, 0) ) ) ), "LENGTH NOT FOUND")

I dont know where to begin when using a function that will keep searching and not just stop at the first match.

I have attached a sample of what i am trying to do.