Spunky

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to create a lookup table with an added varable?	GIZZMO	Excel Worksheet Functions	3	April 6th 09 10:32 PM
Double entry lookup	Al Eaton	Excel Worksheet Functions	2	December 13th 04 03:25 AM
Index table lookup anomaly	Carole O	Excel Worksheet Functions	9	December 9th 04 04:33 PM
Lookup Table	Ben	Excel Worksheet Functions	7	November 30th 04 07:05 PM
double lookup, nest, or macro?	Josef.angel	Excel Worksheet Functions	1	October 29th 04 09:50 AM

All times are GMT +1. The time now is 01:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us