Column_1 Values lookup based on a value and return the adjacent value from column_2

Samk

Link to test case: https://live.datatables.net/zalitado/13/edit

any one know of a way to implement something like a "Vlookup" in the above testcase. i want to return the CPTY value with the Max,Min,and Average Values derived. any pointer in the right direction also appreciated. thanks in advance!

allan

You could use the row selector as a function (row-selector) which will let you select a row by data, then use row().data() to get the data for the whole row.

e.g.:

var rowData = table.row((idx, data) => data.myColumn === 'myMatch').data();

Allan