Spreadsheet Formula read the wrong Value

Question

I run the Vlookup Formula with data like this in he Spreadsheet:

A65     B65    C65         D65             E65            F65             G65
AGR     1      1       Penjualan      12/12/2022       Makanan       15,500

I used formula :

=IFNA(Vlookup(A65,A:D,4,0),"")

should returns the value as "Penjualan" or "" if nothing.

but it returns other value.

Answer 1

your formula is correct unless there is one more AGR in range A1:A64. try:

=IFNA(VLOOKUP(A65, A65:D65, 4, 0))

to see that its working properly