zerovector
New Member
- Joined
- Mar 29, 2006
- Messages
- 8
Hello,
I was wondering why Vlookup would be returning a value when the value does not exist in another table, and I have the Range_Lookup set to 0 (or false).
The value I am looking up is
579190*202
This value does NOT exist in the table (I want it to return N/A)
The value it keeps looking up is:
579190*1202 2.98
Does this have to do with the lookup index being a text value? Does the Range_Lookup not trigger on text values?
When I change the lookup key to
579190202
The value it returns is:
#N/A
Is this normal? Thanks so much
I was wondering why Vlookup would be returning a value when the value does not exist in another table, and I have the Range_Lookup set to 0 (or false).
The value I am looking up is
579190*202
This value does NOT exist in the table (I want it to return N/A)
The value it keeps looking up is:
579190*1202 2.98
Does this have to do with the lookup index being a text value? Does the Range_Lookup not trigger on text values?
When I change the lookup key to
579190202
The value it returns is:
#N/A
Is this normal? Thanks so much