Vlookup or Macro?

[gd6noob]

Hello Everyone.

Im trying to figure out the best way to do this.

What I want to do is:
I have 2 worksheets "Bubble (Image 1)" and "Sheet 2 (Image 2)".
The Bubble sheet I have a mix of names of Direct Hire and 3rd Party hires.
I want to compare the Name and/or ID on the Bubble sheet to the Name and/or ID on Sheet 2 and then have it delete the names that fall under "3PTY" on the Bubble Sheet. I only want to keep names with Employment Type "AMZN". So the Bubble is my actual working sheet and Sheet 2 is only a temp sheet.

I think macro would be best for this but im not very good with it. If someone could help me, that would be great.

Thank you in advanced.


Image 1

Image 2

Image 3

 

[NoSparks]

Could you not add a helper column for Employment Type to the Bubble Report,
populate it from Sheet2 using Vlookup,
then filter the helper column for AMZN ?

 

[gd6noob]

That would work. Would you beable to help me with the forumla or show me a website that could teach me Vlookup?

 

[NoSparks]

Google is your friend.

http://www.excelfunctions.net/excel-functions-alphabetical.html

​

https://www.techonthenet.com/excel/formulas/index_alpha.php
​

something like this in Bubble, say K2 =VLOOKUP($B2,Sheet2!$B$2:$J$75,6,FALSE) and drag down.
replace the 75 with the last row of the sheet2 table.

 

[gd6noob]

Thanks, very helpful...