Hi,

I am combing data from two different sheets. I am using the names as Unique ID(I changed the names for privacy but it is still the same concept). When I find a match, I want the second sheet(Combined) to dispaly the TXRTAREA and EDU form the first sheet(Utility) after the name matching.

I tried using this formula

=IFERROR(INDEX(Utiltiy!$B$2:$D$70,SMALL(IF(Utiltiy!$A$2:$A$70=Combined!$A6,ROW(Utiltiy!$A$2:$A$70)-ROW(Utiltiy!$A$1)),1),COLUMN(A$2)),"")

but it is not matching correctly and not doing the entire list. On my first list which is the Utility sheet there's about 50 names and the second or also known as Combined there's about 70. For whatever reason the last couple of records do not match but they are there in both sheets. I understand that I will have some that might not match since there are not enough records but I am just trying to get the names that do match. I am stuck trying to get this formula working.Thanks.

I also uploaded my file. UtilityMerger TAX FILE ONLINE.xlsx