If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Name not showing ID is | René | Setting Up & Running Reports | 11 | June 29th, 2004 01:40 AM |
STORE multiple values from a lookup table to another table. | beller | Database Design | 0 | June 15th, 2004 04:42 AM |
autotext entry containing table comes in with text in number format | Newt | Tables | 4 | May 20th, 2004 04:31 PM |