Forum Discussion

Steven Lingenfelter's avatar
Steven Lingenfelter
Copper Contributor
Oct 02, 2018

Vlookup problem

Hello   I am having a problem with the vlookup function.  The function works correctly until a certain row.  After that, the function starts returning the value in the previous row.  A screenshot i...
excel
santosh v's avatar
santosh v
Copper Contributor
Oct 03, 2018
I see that the vlookup formula is incomplete (True/False is missing)
VLOOKUP(lookup_value, table_array, col_index, True/False)
  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Oct 03, 2018

    false or 0 is for exact match.

    so it is working OK now?
    good for you..