Thread: Help create this formula:
View Single Post
 
Old 05-02-2020, 07:49 AM
andysvision andysvision is offline Windows 7 64bit Office 2007
Novice
  
Join Date: Jan 2017
Posts: 8
andysvision is on a distinguished road
Default
Quote:
Originally Posted by Guessed View Post
OK, if you are changing the Month in E2 and want the calculation in D2 then put this formula in D2
Code:
=IF(COUNTIFS(OFFSET(G1,1,MATCH(E2,H1:L1,0),21,2),B3)>0,"Yes","No")


WORKS PERFECT!!!!

Thank you!
Last edited by andysvision; 05-02-2020 at 11:28 AM.
Reply With Quote