My Vlookup will not work

[doug firr]

Here's some data:

I have a vlookup like so:
=VLOOKUP(E4,$J$9:$K$12,2,FALSE)

But it returns N/A. Why? Have tried reformatting the data but nothing. E4 matches the top left cell int he example, I know because I checked it with ctrl-F.

What could it be?
[TABLE="width: 132"]
<tbody>[TR]
[TD="width: 66, align: center"][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 138"]
<tbody>[TR]
[TD]https://www.example.com/?cid=300000123[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 66"]
<tbody>[TR]
[TD="width: 66"]10[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]https://www.example.com/?cid=30000333[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]https://www.example.com/?cid=300000456[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]https://www.example.com/?cid=300000789[/TD]
[TD]11[/TD]
[/TR]
</tbody>[/TABLE]

 

[pplstuff]

Doesn't look like your formula is wrong, but I can't see the data.

Two things you should look for... Does E4 exist in J9:J12? If the answer is yes, is E4 or J:J formatted as text and the other formatted as number?

 

[Joe4]

You will get that error message if you do not have a match.
Remember they must MATCH exactly, meaning no extra spaces in one (and not the other) and they must be the same data type (cannot match Text to Numbers).

If you think there is a match, but are still getting this error, there is an easy way to check.
Let's say that you think E4 should match J11, then enter this formula anywhere:
=E4=J11

If it returns FALSE, then regardless of what it may look like, they do NOT match exactly. Just lengths and datatypes.

 

[doug firr]

You will get that error message if you do not have a match.
Remember they must MATCH exactly, meaning no extra spaces in one (and not the other) and they must be the same data type (cannot match Text to Numbers).

If you think there is a match, but are still getting this error, there is an easy way to check.
Let's say that you think E4 should match J11, then enter this formula anywhere:
=E4=J11

If it returns FALSE, then regardless of what it may look like, they do NOT match exactly. Just lengths and datatypes.

Got it! It was one of those staring me in the face days. I was looking up Example Domain against Example Domain - Doh! (note the http)