can lookup return err if no match found
VLOOKUP ( a , b , c, d)
a = what to lookup; can be a hard coded value or a reference to another
cell
b = where to look for it; this is a range of multiple columns but the
lookup is in the first column
c = the column number of "b" that has the value that should be
returned. In your case, column 2
d = False indicator requires exact matches.
Hope that helps.
- John Michl
|