hat
3. Avèk valè ki pi wo a, ou jis ka retounen valè selil la nan kolòn dwat la, si ou bezwen retounen valè a ki nan kolòn gòch la, ou ta dwe aplike fòmil sa a: =INDEX(A2:A11,MATCH(MAX(B2:B11),B2:B11,0))( A2: A11 se seri a done ke ou vle jwenn valè relatif la, B2: B11 se seri a done ki gen valè a pi gwo), ak Lè sa a, peze Antre nan kle. Ou pral jwenn rezilta sa a:
eng
3. With the above value, you just can return the cell value from the right column, if you need to return the value which in the left column, you should apply this formula: =INDEX(A2:A11,MATCH(MAX(B2:B11),B2:B11,0))( A2:A11 is the data range that you want to get the relative value, B2:B11 is the data range which contains the largest value ), and then press Enter key. You will get the following result: