hi everyone,
today’s query is to filter data and apply vlook up in particular column.
I have sheet in which I have to filter empty cell in “number” column of sheet1 and apply vlookup in that filtered column with “number” column of
data.xlsx (12.1 KB)
sheet 1
if it is possible to use linq because i have large amount of data
Hi @lakshya_garg1
Try this approach
Refer the xaml
FilterAndApplyVLOOKUP.xaml (7.6 KB)
thanx for solution
i have little confuse so please do one favour i have change one column name in sheet 1, according to that u change ur code. because that process is not run from my end
data.xlsx (12.1 KB)
@lakshya_garg1
Need to change the column name in if condition also
