I have a list of domain names and their registrars on one sheet, and the same list of domains and other data (but not registrars) on another sheet.
I need to get the registrar name from sheet A, to be next to the corresponding domain name in sheet B.
CSV example of sheet A:
domain1.com,,9.98,03/24/13 domain1.com,,9.98,03/24/13 domain1.com,godaddy,9.98,03/24/13 domain2.com,,9.98,03/24/13 domain2.com,godaddy,9.98,03/24/13 domain3.com,namecheap,9.98,03/24/13
CSV example of sheet B:
domain1.com,1200,04/01/14 domain2.com,402,04/01/14 domain3.com,612,04/01/14
I desire to have the registrar in a 4th column of sheet B for each domain.
The problem is that on sheet A, there are multiple instances of the domain where it was with other registrars in the past, but those cells have been erased. This causes my vlookup from sheet B, to find the first match of the domain name and return the corresponding registrar, which ends up being blank (returns zero).
Is there a way to get a VLookup (or other formula) to return only a corresponding registrar that is NOT blank?
I've experimented a bit with Index & Match but wasn't able to get any closer.