How to get value if Duplicate Column Name

[anmita]

Hii Team,

We are having a sheet in this format

How can we find for CN12 the Q2 Percentage from column H

Output expected: 0 for Q2 CN12

I have tried the following approach
1)To find the value using lookup
But during read range it gives duplicate name exception

Any other approaches are welcome:)

Have also attached the file
CN12 .xlsx (5.5 KB)

[258761160]

@anmita

Output expected: 0 for Q2 CN12

Read Range Workbook AddHeaders should be set false

[Srini84 (Srinivas Kadamati)]

@anmita

Yes, it will give duplicate name exception, but you can remove the add headers property to uncheck

So, that you can try with the Lookup and see

Thanks,
Srini

[anmita]

Hii @Srini84

Have tried that method but it was still giving some exception

So wanted to know other alternatives

Thanks @Srini84 for suggestion

[supermanPunch (Arpan)]

@anmita

Have tried that method but it was still giving some exception

Hi @anmita ,

Could you let us know what was the Exception that it was producing when the Read Range activity Add Headers was unchecked ?

[anmita]

Hi @supermanPunch

Just checked yes by unchecking it working

Previously had added some other data table manipulation so it was giving those exceptions

Thanks again