On 21:41 Fri 04 May , Joe Smith wrote: > JosephK wrote: > >... > >Most of the lookup returns a correct cost price but some items return N/A > >The cost prices are in a named range 'costprices' > >VLOOKUP(A123:costprices;2;0) for SOME entries fails but if I substitute > >the actual range it returns the correct value > >i.e. VLOOKUP(A123;Prices.A1:B234;2;0) succeeds > > > >As to the failed entries e.g SANYO TRC860 returns the correct price > >SANYO TRC695 returns N/A > >... > > I can't account for the named range observation, but have you checked > that there is actually a matching 'SANYO TRC695' entry? The text strings > must match exactly; 'SANY0 TRC695' or 'SANYO TRC695' or 'SANYO TRC695 ' > won't match. I'm not sure if the letter case also has to match. > > If you can verify that the strings match exactly and the lookup works > with the explicit range and not with the named range (assuming the named > range is correct and refers to exactly the same cells), then there may > be a problem. > > I'd say report it if you can provide a sample document demonstrating the > error. > > I've not seen a problem like this with vlookup, but the named range > support seems less mature IME. > > <Joe > The text strings match exactly. That was the first thing I checked. When I return to work next week I shall copy the calc file and see what happens on my home setups (Debian stable, testing and Win XP)
It is often safer to be in chains than to be free. Joseph K --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
