Use vlookup on filtered data

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_Garg - Could you please explain what is the data that you are looking for using vlookup ??

3

you can easily understand through the excel file

4

please check “ckycid” column ofthe output sheet
data.xlsx (13.2 KB)

5

Check this thread