Hi there : I am trying lookup value based on multiple criteria (including date ranges). I am exploring different options such as Xlookup and Index/Match. When I use the Xlookup I get the correct result but when I utilize Index/Match functions I am getting #N/A values. I am not sure why the error is occurring. Any help to troubleshoot the Index/Match functions in this scenario would be greatly appreciated. Please see below the link for the functions that I tried
https://1drv.ms/x/s!Amc8fiGpDxeki3i1ixWIy2SWdmEE?e=dtm6gj
Many Thanks

92382-image.png
