Someone please help before
I have added a Vlookup to a spreadsheet but it is consistently throwing up #N/A even though the look-up value is most definitely in the array I have selected. I assumed that there was a formatting error as the data was imported from elsewhere but I have tried Text to Columns, TRIM, CLEAN etc. I have also applied (Len) to check characters in the cell and multiplying cells by one and then copying with paste special and values and also ISNumber() which has given TRUE in all cases. The look-up value is in column A and I have checked and double checked the column number in the table. I have formatted the column showing #N/A and the only thing with that column which makes me think I am missing something there is that a cut and paste formula was recorded in the cell purely as text.
Any helpful advice gratefully received.
I have added a Vlookup to a spreadsheet but it is consistently throwing up #N/A even though the look-up value is most definitely in the array I have selected. I assumed that there was a formatting error as the data was imported from elsewhere but I have tried Text to Columns, TRIM, CLEAN etc. I have also applied (Len) to check characters in the cell and multiplying cells by one and then copying with paste special and values and also ISNumber() which has given TRUE in all cases. The look-up value is in column A and I have checked and double checked the column number in the table. I have formatted the column showing #N/A and the only thing with that column which makes me think I am missing something there is that a cut and paste formula was recorded in the cell purely as text.
Any helpful advice gratefully received.
Comment