I am constantly running into difficulties with vlookup and believe the problem is related to the columns not properly identified as numbers. I am really not sure how to change the format properly so that it “sticks”. If I look at a cell and use format, it shows the cell correctly formatted as number but vlookup fails and the little triangle in the top left corner appears.
Is there a recommended way to convert the relevant column into number formatting.