I have a sheet with 13 digit numbers, I am then trying to vlookup to pull out some more data, the number is there but it comes up with N/A until you physically click in the cell and press enter then it works.
Is there anyway I can do this process in bulk rather than clicking in each individual cell.
There is over 4k cells.
Cheers
Bookmarks