Find Value of Write Cell if Column name repeated

[anmita]

Hi Team,

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

Have attached the Sheet
India Sales Data.xlsx (5.7 KB)

[Anil_G (Anil Gorthi)]

@anmita

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

Hope this helps

Cheers

[Yoichi]

HI,

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.

dt.Rows(0)("March-23_Employee Posted No_Q1") 

Sample20230320-1L.zip (15.2 KB)

Regards,

[anmita]

Thanka @Anil_G

[anmita]

Thanks @Yoichi for sharing the sample