Need a formula to delete after comparison in Excel-CodePudding

I have two Excel sheets.

First Excel has list of 89000 user names and their storage space which I generated.

Second Excel has list of 2700 user names whose storage I have to fill.

I have tried online solutions like formulas of if is error and some conditional.

They are giving the expected results.

Can anyone please reply with a formula which will compare 2700 users with 89000 users so, I can get the 2700 users Storage metrics ?

Assume :
Column A has 89000  user names
Column B has Storage of 89000  users respectively
Column C has 2700  user names.

Note : you can change the order of columns if it will give the answer.

I request the help of this community as this is important. Thanks in advance.

CodePudding user response：

Assuming the usernames are unique, and the column layout is the same as described above in a single sheet, in cell D1 enter =VLOOKUP(C:C, A:B, 2, FALSE) (and press ctrl shift enter if not in Office365).