I have a excel , in which i want to opening the sheet and user will find the grade which is “K6701” and under this grade it will find the location as “Mumbai” and fetch the value for the same grade under Mumbai City..... How is it solved?

[Prathamesh_Chavan]

01-12-2022-PVC-reliance.xlsx (113.5 KB)
Here is the excel , plz find out the best solution

[Prathamesh_Chavan]

Guys please help me for this use case

[Vishnuraj_Pandiyarajan2 (Vishnuraj Pandiyarajan)]

Hi @Prathamesh_Chavan

you can use below activity

then take range for Read range activity

then use lookup data table activity to get your output value

please try this below .xaml,
Hope you will get solution.

BlankProcess.zip (370.7 KB)

Thanks & Regards
VP

[Prathamesh_Chavan]

Thank you so much , its give me an total idea about it …