Hi i know this is a pretty basic problem but for the life of me i cant search for the right solution.

I have two columns one with names and the second with emails.

Names Emails
Ben b@b.com
James j@gov.au
Rick rick@gov.au

What i want is to find all emails with .gov.au in them and then select the cells on the left of those emails that contain the corresponding names

That way i can copy them into a new sheet.

Any help at all would be much appreciated theres 6000 records and selecting them individually will be a pita!

Thanks.