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)

@lakshya_garg1

Do this modification

image

already try not working

@lakshya_garg1

Need to change the column name in if condition also

image