I have a list of DNS entries that I need to sort to get the good records.
In sheet1, I have a dump of the raw data, in column 1 is a zone ID which is a number.
In sheet2, I have a column made up of the zone ID's that I want to keep.
On sheet3 I am looking for a way to take sheet1 column 1, to see if it matches one of the values in sheet2 column 1. If it does, then the result should be the entire row into sheet 3.
Is this possible? Data example is below:
Sheet1 - 4 columns
1 foo A IP_Address 1 foomaster CNAME IP_Address 392 jimmy A IP_Address
In column1 is a list of acceptable zone ID's I want.
If value from sheet1-column1 exists in sheet2-column1, paste the entire row from sheet1.