1–8

VLookup argh!

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: Monsoir (PILOTDAN)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: Monsoir (PILOTDAN)16 Nov 2011 14:21
To: Monsoir (PILOTDAN) 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 PILOTDAN
Reply
0/0