lookup misses the first entry in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing data in different columns or worksheets 2
Lookup returning wrong results 0
First row where a cell is zero 1
LOOKUP HELP PLEASE 1
Referencing relative to a formula reference 3
Lookup value off by one row 2
Lookup for the first occurrence 4
Lookup table 3

Back
Top