VLookup and Index-Match not giving the desired results

[Former Member]

Hello,

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?

Thanks,
Arun

[amit_mathur]

Hey Arun,

Try to refresh your connection manually(not refresh on load) and test. Also take snapshot of current excel data from preview to check if the data are coming from connection and could be an issue or delay on formula execution.

Regards,

Amit

[Former Member]

Thanks Amit.

Value is displaying on the excel snapshot but not on the chart. Any reason?

When you say manual refresh what do you mean?

Arun