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