After learning a few things from previous post, I am now stuck again trying to understand why the below formula is giving me an NA,
I did it in two ways that has worked in the past bu not any longer in the attached document.
1. =INDEX(Sheet2!$D$2:$D$76,MATCH(B2,Sheet2!$B$2:$B$76,0))
2. =INDEX(Sheet2!$A$2:$D$76,MATCH(B2,Sheet2!$A$2:$A$76,0),4)
The desired result is sheet2 (D2) date to populate in sheet1 C2 and D2 from the above to formula
Still learning. Thank you.
Bookmarks