Why doesn't VLOOKUP find values even though they exist?

U

Username2018-10-01 21:14:06

excel

Username, 2018-10-01 21:14:06

Good evening!
There is Sheet 1 , which contains column B, which is searched in Sheet 2 for cell A. What could be the matter?
Download Example.xls

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

B

Bcoon, 2018-10-02
@Volunteer

Sheet2 has a space after the first two values. Because of this, the lines do not match. Remove the extra space at the end of the values and everything will work