Alternative to vlookup? 1

[dgillz]

I need to perform a vlookup() on a table, but vlookup will return a value without an exact match. How do I get vlookup to return a value only with an exact match? Or is there another function that does this?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[SkipVought]

Hi,

"...but vlookup will return a value without an exact match."

Not so!

Use FALSE for the range_lookup argument.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}