Vlookup was just not working

I was trying to use the simple and ofcourse the complex formula of vlookup, and it was just not working. I tried every possible solution but it just won’t budge. And then as always the solution was simple when I found it (thanks to my husband but couldn’t he tell me that before).

Possible cause of VLOOKup not working:

  1. The column which you are performing the vlookup should be on the left
  2. There should be no trailing spaces anywhere in the cell
  3. The columns should be of ‘text’ format
  4. Sometimes if there are many columns that could create an issue. Make a separate sheet and copy only the relevant columns and try vlookup

The final solution:

VLOOKUP( lookup_value, table_array, col_index_num, [range_lookup] )

  1. The lookup_value should be a single cell not the entire column
  2. table_array – This range should be locked. Select the range and press F4 to freeze the values