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.
