I am trying to use lookup using a vector and array. My lookup is in column
A500 thru A550. I need to locate the information in Column D1 thru D800 and
return the result from Column F1 thru F800. If nothing is found I need it
to return the result of 0. I havetried many times with no results. What to
do now.
Rose