Vlookup between two different excel spreadsheet input

[AntlRo]

Hello everyone..

I have two excel files and I'm trying to do a vlookup from one excel to another using Alteryx. Basically to get this automated monthly without human intervention if possible. The data has thousands of rows, this is just a short snipit to provide the logic to the thousand of rows. 

Below is how the spreedsheet looks ( keep in mind it has more columns and rows, this is just a short snip it)

Example::

"Spreadsheet1.xlsx"

User	Computer	Status	Vlookup Computer Name
Bobby	Dell123
Nomad	Hp789
Henry	Macbookbook345

Now below is spreadsheet2,  we are comparing spreadsheet 1 values to get spreedshet 1 values updated. 

- On spreadsheet2 we will look to see if the "Computer" Column values from spreadsheet 1 is there

- If the "Computer" name are in spreadsheet2 then update column "Vlookup Computer Name" with the Computer name ie "Dell123" and change column status  to "new"

-If "Computer" name is not in speadsheet  2 then update spreadsheet 1 "Vlookup Computer Name" to NA and status to "Closed" on spreadsheet 1

spreadsheet 2.xlsx

Computer

Sonic123

Hp789

MacbookPro981

Final output: Spreadsheet 1 with the following updates( note: make the computer column to match the values from spreadsheet2 not just the computer name):

User	Computer	Status	Vlookup Computer Name
Bobby	Dell123	closed	NA
Nomad	Hp789	New	Hp780
Henry	Macbookbook345	closed	NA

[grazitti_sapna · Accepted solution]

@AntlRo , here is a solution to your problem. let me know if it was helpful or if you have any doubts.

[ShankerV]

Hi @AntlRo 

One way of doing this.