View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Why is VLOOKUP returning a value from the row above?

Be sure to include the False:

=VLOOKUP(something, some_array, some_column, FALSE)
--
Gary''s Student - gsnu200907


"Summerfun" wrote:

The VLOOKUP function is returning a value exactly one row above the row it
should be using.