Comparing three columns and giving back specified values

Closed
sepideh.ha Posts 1 Registration date Monday July 28, 2014 Status Member Last seen July 28, 2014 - Jul 28, 2014 at 11:00 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Jul 29, 2014 at 11:57 AM


I want search for strings I have in source(A) in both source(B) and source(C) and when it finds those documents give them the three revisions I have from different sources. I mean each string(cell) I will have with three revision, one for itself and two revisions from source B&C.

1 reply

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Jul 29, 2014 at 11:57 AM
Hi Sepideh.ha,

Next time posting a pic change 325px in 500px at the end of the picture code line, so that is actually readable (I don't blame you for not knowing).

Your query is rather vague. I get that you want to compare column A to E and H (I believe those are the column letter from the pic).

So if A=E and A=H then ... And there you lost me. Which data you want to put where is not clear to me.

Best regards,
Trowa
0