Sorry Rob. I don't know very much at all about spreadsheets so I can't answer your question. Seems like it should be possible to do what you want.
But as I said before, if you are going to run into spreadsheet size limitations anyway, maybe you should be working with a database, and then your spreadsheet view into the database and the charting of the data might be much simpler. On Thu, Oct 23, 2014 at 10:14 AM, Rob H <[email protected]> wrote: > Thank you so much for your help Daniel - been doing a lot of playing. > > You can see on my spreadsheet I've managed to get a single value by > matching the index : > https://docs.google.com/spreadsheets/d/1CktfyseItSCYQa9isaFSiESBKhwgUn-mY4NZ7OIiN2A/edit?usp=sharing > > *=index(AEA,match("77ABC",UPN,0))* > > So - do you know a way I could get all three of these values in one call > using this index match method? > > Seems to be the only way I can target a single value from a single > reference point. > > Thanks in advance :) Rob > > -- > You received this message because you are subscribed to the Google Groups > "Google Chart API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/google-chart-api. > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> - 978-394-1058 [email protected] <[email protected]> 5CC, Cambridge MA [email protected] <[email protected]> 9 Juniper Ridge Road, Acton MA -- You received this message because you are subscribed to the Google Groups "Google Chart API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-chart-api. For more options, visit https://groups.google.com/d/optout.
