hat
Pa egzanp, ou ka itilize fòmil VLOOKUP la tankou sa a = VLOOKUP (B2, A8: B14,2), Lè sa a, ou trennen okipe a manyen okipe nan yon seri ou bezwen, ou ka jwenn rezilta yo mal tankou anba a Ekran yo montre:
eng
Generally, you may use the VLOOKUP formula like this =VLOOKUP(B2,F2:G8,2) then you drag the auto fill handle to a range you need, you may get the wrong results as below screenshot shown: