1–8

VLookup argh!

From: Radio15 Nov 2011 12:45
To: ALL1 of 8
39110.1

Anyone know why the Vlookup in this excel sheet isn't working?
I can get it to work if I type the actual number in, but not if I reference the cell, and I can't work out why!

Attachments:
Reply
0/0
From: Radio15 Nov 2011 13:24
To: ALL2 of 8
39110.2
Sorted it, but still not sure what the underlying problem is. But putting an INT() wrapper around the cell reference did the job.
Reply
0/0
From: Drew (X3N0PH0N)15 Nov 2011 14:22
To: Radio 3 of 8
39110.3 In reply to 39110.1
Try putting an INT() wrapper around the cell reference.
Reply
0/0
From: ANT_THOMAS15 Nov 2011 14:32
To: Drew (X3N0PH0N) 4 of 8
39110.4 In reply to 39110.3
That will never work.
Reply
0/0
From: Radio15 Nov 2011 14:37
To: Drew (X3N0PH0N) 5 of 8
39110.5 In reply to 39110.3
Amazing, thank you!!!! I owe you many beers!
Reply
0/0
From: Drew (X3N0PH0N)15 Nov 2011 15:25
To: ANT_THOMAS 6 of 8
39110.6 In reply to 39110.4
HA, SEE!!
Reply
0/0
From: Dan (HERMAND)16 Nov 2011 14:16
To: Radio 7 of 8
39110.7 In reply to 39110.1
It's because your numbers are stored as text.
Reply
0/0
From: Dan (HERMAND)16 Nov 2011 14:21
To: Dan (HERMAND) 8 of 8
39110.8 In reply to 39110.7

To clarify - it's because your lookup value is text, and your lookup table are numbers. You need to search like for like.

 

Edit: This doesn't seem to be entirely true, but I can't be bothered to investigate it further. However, the root cause is as above.

EDITED: 16 Nov 2011 14:27 by HERMAND
Reply
0/0