hat
Tanpri antre nan fòmil sa a: =index(A1:A16,match(D2,B1:B16,0)) nan yon selil vid kote ou vle mete rezilta a, ak Lè sa a, peze Antre nan kle, valè a matche soti nan kolòn nan bò gòch yo pral retounen jan sa a Ekran yo montre:
eng
Please enter this formula: =index(A1:A16,match(D2,B1:B16,0)) into a blank cell where you want to put the result, and then press Enter key, the matching value from the left column will be returned as following screenshot shown: