Hello! For example,I have some specified date in excel sheet1.And all dates in sheet2.I want if one date from sheet1 matches with dates in sheet2(full date range) ,then it should give the value above date in sheet2.
I have used this formula: =if(C5=Sheet2!J3:U3,Sheet2!J1,0)
I have got error called #VALUE!.
Please help me with this error.
Solved by E. C. in 19 mins