colA colB colc

[workshop]

colA colB colc colD
1a 2b 1a
2b 3c 2b 2b
3c 4d 4d
4d 5e 5f 4d

Please help, what is function that I can use in colD that the value either in colB or colC match each other and if there is a match then the value is match will put in the same row of value in colA. example like 2b and 4d in colD

Thank you in advance

 

[ETID]

Please rephrase....

 

[DaleWatson123321]

I TOTALLY agree with ETID - Your example needs clarification.

Based on what you've described, all one can do is "take a guess" as to what you mean.

"For the fun of it"... here's my guess, based on your description and data...

The formula for column D:
=IF(B3=C3,A3,"&quot

Explanation:

For row 3 which contains: 3c, 4d, 4d, the above formula will be TRUE
- because... your words:
"value either in colB or colC match each other".

Being TRUE, it will return... "3c"
- because... your words:
"if there is a match then the value is match will put in the same row of value in colA"

How close was this ???

Regards, ...Dale Watson

HOME: nd.watson@shaw.ca

 

[workshop]

what I like to do is to find the value in colC or colB match to each other(like 2b and 4d) with the match value then match again with colA and result in the same row of colA but in colD

 

[ETID]

I don't see that in your example...what am I missing?

 

[workshop]

in the first post

 

[ETID]

Are you saying that for each row in colA, see if there is a match in colB or ColC and if true then colD for that row will mirror colA for that row?

 

[workshop]

colB and colC has to match to each other first and use the match value to see where it stand in colA and put the value there

 

[ETID]

try filling this formula down in col D...assuming you have headers in row 1



=IF(AND(COUNTIF(B:B,A2)>0,COUNTIF(C:C,A2)>0),A2,"&quot

 

[ETID]

try filling this formula down in col D...assuming you have headers in row 1



=IF(AND(COUNTIF(B:B,A2)>0,COUNTIF(C:C,A2)>0),A2,"&quot

 

[ETID]

Still there?