Lookup Function with missing values 1

[Andie]

I am using the look-up function to connect codes with users. However in some cases, we may have a code that is not listed in the look-up vector. I know that the look-up function, by default, goes to the next lowest value in the vector. Is there a way around this so that it will tell me if the code doesn't exist in the look-up vector? (something as simple as NA or blank will do) Or should I be using something different?
Thanks!

 

[ETID]

and ,false to the end of you lookup formula I.E.

=vlookup(a1,n120,2,false)

 

[ETID]

oops ..I mean add

 

[Andie]

Great! Thank you very much!

 

[DaleWatson123321]

To "Andie"

In checking your profile, I see that you have been a member of Tek-Tips for awhile, but have not yet "shown your appreciation" by issuing a "STAR" to anyone. "Naughty, Naughty".

Actually, I'm sure you simply were NOT aware of this accepted "normal method" of showing FULL appreciation, and once you become aware, you will no doubt be more than willing to issue STARS to "formally say thanks" to those who provide contributions.

The issuance of a STAR is simply done by clicking the "Let ______ know this post was helpful" in the lower-left-corner of the contributor's posting.

And, as mentioned before, these STARS also serve as "beacons" to other Tek-Tips users who are looking for solutions to the same or similar problems.

I hate to keep repeating these points, but I believe someone has to. Contributors spend valuable time in dealing with these problems, and should receive a form of "tangible" recognition. The STARS serve that purpose.

Because Andie no longer has this posting marked, I will ensure "ETID" receives his (deserved) STAR.

BUT PLEASE DON'T issue a STAR to me for THIS "tip" to newcomers. I did receive a STAR for one SUCH "reminder", and while "touching", I would prefer to EARN my STARS the "normal" way ...i.e. by actually SOLVING someone's problem.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[ETID]

Glad to help