How can we get cell value H4
Example : India having code INXX088 for Q1 as the column name it should return cell H4 but the Columns here are duplicated so lookup cannot be considered
You can read data starting from the first column name(country) till the end(the second Q4)…read without add headers as column names are same…
Now you can use filter datatable and remove the unwanted columns and create two different datatable one with first Q1 to Q4 and other table with the second Q1 to Q4
Then you can perform look up as you needs …on either of the tables
We can rename each column from content of the datatable.(Initially read range without headers)
The following is a sample for this. Finally we can access value of H4 using the following expression.