Thanks so much! Yeah, I know the there was alot of inconsistencies in the data, which I knew would be hard to find; however I knew the right combination of formulas would yield a majority if they have any close matches. Sample 4 and Sample 5 in some instances pulled different information, so I will compare those two and take all values in Sample 5 that returned and use those values if Sample 4 did not return a value for the same item in the Item field.