Hi, i'm trying to do a vlookup up formula in column N, this looks to match the values in column L with the values in column B and return the value from column E.
The data in columns A:F is updated with a macro. The data in J:N is used in a report.
I know what the problem is, that the date and time in column B has an extra space between the date and time, hence why the vlookup wont work. But i dont know how to solve this?
The data that the macro takes from another worksheet does not have this extra space in it.
Solved by K. D. in 17 mins