Referencing data for a chart from a different sheet

[Johnmu]

Hi,


I have a list of product data summarised in one sheet and detailed data for those products in a second sheet. Next to each product in the first sheet I have a Sparkline describing 12 months performance. The data for the sparkline is in a range called "Actual" in the second sheet. The products in the two sheets are not in the same order. I am currently generating the Sparkline data manually but this hardwire approach is not feasible in the long term as the order of the products in the first sheet changes dynamically. I need to use the product name in the first sheet to lookup the data range in the second sheet as a reference for the sparkline. How can I do this? All help appreciated.

Cheers

John

 

[Stu Dapples]

Is it not as simple as a VLOOKUP?

=vlookup(cell where you product name is, range will be the dynamic list of products INCLUDING THE VALUES!!, offset by the required no. columns, false)
(will only return exact match)

Hope that helps!

 

[Johnmu]

Thanks for the fast response Stu...

I tried the vlookup but that just returns a single value.. What i need returned is a range of data that I can use to generate the chart.. Am I missing something in your reply?

John