lookup misses the first entry in table

If I insert a row with a number less than 074 first, the 074 does as I expect
on my spreadsheet. However, if I have it as is below, any lookup to 074
returns n/a, however the rest of the numbers below return as I expect. What
am I missing in order to not put in a line I really don't need?

ISBN Category
074 Books
078 Books
088 Books

use vlookup or hlookup

vlookup(lookupvalue,rangeToLookup,columnTo_lookup,false)
The false indicates the lookup range is not in order.
Lance


"Spunky" wrote:

> If I insert a row with a number less than 074 first, the 074 does as I expect
> on my spreadsheet. However, if I have it as is below, any lookup to 074
> returns n/a, however the rest of the numbers below return as I expect. What
> am I missing in order to not put in a line I really don't need?
>
> ISBN Category
> 074 Books
> 078 Books
> 088 Books
>
>