Finding matches inside a whole column?

Hi, I have a 4 column excel sheet that I am working with.

Col A: Values of Circuits (1)
Col B: Values of Circuits (2)
Col C: Values of possible values

In Column D, I want to find the matching Value of Circuit 1 (column A) that exist in the whole column C.

For example

A1 = aaa C1 = aa1
C2 = aa2
C3 = aa3
C4 = aaa

A2 = aa2 C1 = aa1
C2 = aa2
C3 = aa3

etc, etc, etc for each A
I would want D1 to say aaa

This would be the same with Column E, except instead of using the data for Column A, it would be the data from Column B still running through all the values of the entire Column C

This would be done for C1 --> C9999.... etc, etc

Thanks!

Hi,

I don't think we have enough information. How do you get aaa in D1 when aaa only exists in C4? Is it simply that once you find a match you report it?

What data is in column B?

How about extracting a unique list of values from column A, in say column D, then using the Match function

=IF(MATCH(D1,C:C,False)>0,D1,"")


It might be better if you could upload an actual workbook with all the values, or at least a reasonable sample of them, and manually note what you want in each cell and how you make that decision.

Rgds

Thanks for the reply. Here is the excel doc. Thanks!

It has over 1000+ fields but I deleted it to simplify what I'm looking to get done. Thanks again!

Hi,

If I understand your request correctly, your problem is caused by the fact that the column F values have trailing spaces, whereas the test values in cols A & D don't

Either get rid of them or change the vlookup formula to:

=VLOOKUP(TRIM(F2),A$2:A$30,1,FALSE)

HTH

Thanks a lot! I will try that with the full spreadsheet!!!