if condition

[yaelcohen]

Hello expert,

Thanks for any help,

In the attached file you can find my question.
How I can indicate all the firm-year that exist in both tables.
The indication should be the word FILE
I wrote a condition in column G and I do not know
what is the problem

Thanks a lot!

 

[Khalid NGO]

Hi,

See if this works:

=IFERROR(INDEX($C$4:$C$7597,MATCH(E4&F4,INDEX($A$4:$A$7597&$B$4:$B$7597,),0)),0)

Regards,

 

[yaelcohen]

Thanks a lot!!!!!!!!!!!

 

[Ashhu]

i understand that , if any details exist in A,B and E,F..Column G should have "File" filled.
Try below one.

=IF(($A$4:$A$7597=$E4)*($B$4:$B$7597=$F4)=0,C4,"")

 

[yaelcohen]

thanks a lot!

 

[Khalid NGO]

Hi,

Adding one more simple way with COUNTIFS, just to confirm as I am getting completely different answers as compare to Ashwin's post # 4:

=IF(COUNTIFS($A$4:$A$7597,E4,$B$4:$B$7597,F4),C4,0)

Regards,

 

[yaelcohen]

Hi,

Adding one more simple way with COUNTIFS, just to confirm as I am getting completely different answers as compare to Ashwin's post # 4:

=IF(COUNTIFS($A$4:$A$7597,E4,$B$4:$B$7597,F4),C4,0)

Regards,

Sorry for my late reply. you are right. your solution is different than answer #4 and equal to answer #1