How to filter data and apply vlook up

Help Studio
, ,
1

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

2

Hi @lakshya_garg1

Try this approach

image
image721×449 13.4 KB

image
image709×547 12.9 KB

Refer the xaml

FilterAndApplyVLOOKUP.xaml (7.6 KB)

3

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)

4

@lakshya_garg1

Do this modification

image

5

already try not working

6

@lakshya_garg1

Need to change the column name in if condition also

image