VLookup and Index-Match not giving the desired results
I am using Vlookup for selecting values coming from BIWS and displaying it on a chart. But the values are not displayed correctly. I am selecting country and year for displaying 8 different revenue values on a chart. The display is not showing all the eight values, it displays none sometimes, sometime 2, 3 etc. What could be the reason? Any suggestions?