Hi Folks
Need a formula to look for matches across two worksheets and return "Yes" or "No" if matching data is >=5
Sample attached
Cheers
hammer
Hi Folks
Need a formula to look for matches across two worksheets and return "Yes" or "No" if matching data is >=5
Sample attached
Cheers
hammer
If you have found solving my problem/s to be an interesting and educational exercise then how about Repping me up?
No idea why I need Rep, other than feeling left out....
E1=IF(SUMIFS(INDEX(DailyAdj!$E$2:$CM$10,,MATCH($D1,DailyAdj!$E$1:$CM$1,0)),DailyAdj!$A$2:$A$10,$A1,DailyAdj!$B$2:$B$10,$B1,DailyAdj!$C$2:$C$10,$C1)>=5,"Yes","No")Try this and copy towards downPlease Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Great work yet again nflsales!
Thanks so much for your time!
Great work yet again nflsales!
Thanks so much for your time!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks