The key skill I have for you today is not directly related to Jasper, but how best to move the data around in a spreadsheet.
Today’s Lesson: VLOOKUP
I will give you a simple example that can be easily applied to any data set. Let us say I have a set of customer numbers and their current account balance.
So long as you know your Customer Number is to the left of the data in your table, you can use VLOOKUP to find that information.
Type into the Red Cell:
Have more questions about the M2M Control Centre or want some training?
Contact your M2M One Account Manager.