JeteMc: I agree with you in that I did not include details in my original post. I am providing details here to avoid my initial pitfall.
The sample file works this way:
Note: Only need the formula into column J fixed as I was able to create three helper columns to extract desired values in column D into column I.
Part A: Values in column C are manually entered in cell A2. (black column and text appear in white color)
For example, if you enter the two letters AA (C3= AA21259159) in A2, Tbra, Cable is automatically pulled into I2 since that is the only AA in column E.
Part B: Looking for formula to extract the value (in column D) matching Tbra, Cable in column I into column J. For the sample in Part A, the formula should return AA21259159
Example II:
if you enter the two letters TA (C2= TA32785655,C31=TA53245548, C32 = TA13291311) in A2, Tbnor M., Aadigan, Tbnor, Aadigan, and Tbnor, Aadigan
are automatically pulled into I2:I4 since those are the ones with TAs in column E.
Example III:
Example II:
if you enter the three values TA3 (C2= TA32785655) in A2, Tbnor M., Aadigan is automatically pulled into I2 since it is the only TA3 in column E.
See sample file.
Thanks.
Bookmarks