--- "G. Roderick Singleton" <[EMAIL PROTECTED]> wrote: > On Wed, 2005-04-20 at 15:33 +0100, Steve wrote: > > Is there a limit to the size of the vector it can lookup? > > > > LOOKUP(LEFT(C18;3);A8:A14;D8:D14) > > > > This looks a bit sparse to me. Try LOOKUP((LEFT(C18;3));A8:A14;D8:D14) > > [snipped]
Help gives this format: LOOKUP(Search criterion;Search vector;result_vector) Search criterion is the value to be searched for; entered either directly or as a reference. Search vector is the single-row or single-column area to be searched. result_vector is another single-row or single-column range from which the result of the function is taken. The result is the cell of the result vector with the same index as the instance found in the search vector. Maybe I should try VLOOKUP though I am unsure how they work! Send instant messages to your online friends http://uk.messenger.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
