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]
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]