Use vlookup on filtered data

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

you can easily understand through the excel file

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

Check this thread