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?

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

1 Like

Guys please help me for this use case

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

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.