Forum Discussion

Steven Lingenfelter's avatar
Steven Lingenfelter
Copper Contributor
Oct 03, 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 it attached

excel
  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Oct 03, 2018
    can you attach a non-sensitive file - so people here can have a better understanding of your query.
  • 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..

Resources