View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default 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