Vlookup / Linq in google sheets

Help Activities
, ,
1

Hi Team,

I would like to apply vlookup / some other technique to find the common fields in GOOGLE SHEETS(not in normal excel)

sheet 1: Deactivated users

image
image1343×873 167 KB

sheet 2: New Portal Extract

image
image1696×904 173 KB

Ideally, no values present in sheet 1 should be present in sheet 2, i.e. none of the Deactivated users must appear in the New Portal Extract with a Full licence.

If any users in the Sheet 1 appears in Sheet 2 , then we need to extract those rows of data and paste to a different worksheet (Sheet no : 3) in the same Google sheet with the name “Downgrade status”.

One of my friend said, we could use Linq. But, I am not sure how to execute it. Can someone help me with the same.

2

Use the Google activities to Read Range both sheets into datatables. Then do a Join Data Table (left). If there are rows in the final datatable from the Join, it means there were matching rows which you can now Write Range back to a new sheet.