How to filter data and apply vlook up

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)


Do this modification


already try not working


Need to change the column name in if condition also