Values not returned by Index, Match when using values from Data Validation

**Avinashch** · 05-09-2015, 12:59 AM

Hi All,

I have created 2 Data Validation lists. The second is a subset of first, using indirect function. When I am trying to retrieve values from the data sheet using value from the list as a parameter, its giving out error.

I am attaching the sheet for your reference.

Help shall be highly appreciated.

Thanks and regards.

**FDibbins** · 05-09-2015, 01:18 AM

I dont know where the data in the sub DV is coming from, but A18 has a leading space that the data does not have

**samba_ravi** · 05-09-2015, 01:33 AM

see the attached file

**Avinashch** · 05-10-2015, 10:34 AM

Hi Siva,

I am not quite able to understand the function. Could you please rectify the #N/A in the values columns and send it to me. So that the values for the columns would also change with the country.