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

U

U

Username2018-10-01 21:14:06

excel

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

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

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

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

Similar questions

M

MorelBezos2021-03-17 06:33:45

How to make a pie chart in excel? 2Reply

D

Dima2017-03-27 19:54:40

Is it possible to suppress Excel's prompt to select an xslt schema when opening an XML file? 0Reply

E

eldar_web2017-03-28 18:59:30

How to upload an excel file in Ruby on Rails so that it can be opened on android? 0Reply

D

Dmitry Largovich2015-04-02 15:16:34

How to make one Excel file display data from another Excel file? 2Reply

D

Dimich582019-09-03 16:53:31

Upload data from browser to excel? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question