#Table 1 contains the find and replace values; @AoA = ( [ "jones", "B0"], [ "smith", "B1"], [ "adrew", "B1"], [ "larry", "B3"], ); #the 2nd table contains the data that I want to search in. @AoA2 = ( [ "jones", "AAAAA", "BBBBB", "CCCCC"] [ "aaaaa", "AAAAA", "larry", "CCCCC"] [ "jones", "AAAAA", "BBBBBB","CCCCC"] [ "DDDDD", "AAAAA", "BBBBBB","larry"] [ "jones", "AAAAA", "andrew","CCCCC"] [ "jones", "smith", "BBBBBB","CCCCC"] );