Microsoft KB Archive/74986

{| = Lookup_value Examples Incorrect in Excel Reference Manual =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q74986

SUMMARY
The following statements are found in the &quot;Microsoft Excel Function Reference&quot;:

Page 123: If HLOOKUP can't find lookup_value, it uses the largest value that is less than or equal to lookup_value.

Page 246: If VLOOKUP can't find lookup_value, it uses the largest value that is less than or equal to lookup_value.

The words &quot;or equal to&quot; should be removed from these statements. If lookup_value can't be found, a value that is equal to lookup_value will not be found either.