If you're copying the formula, you need to make the search range absolute. Otherwise the start point moves down as you copy. Do this:
LOOKUP(LEFT(C18;3);A$8:A$14;D$8:D$14)
tc
Steve wrote:
Is there a limit to the size of the vector it can lookup?
LOOKUP(LEFT(C18;3);A8:A14;D8:D14)
This will only lookup in the first four rows specified within the vector. Column A8:A14 is the days of the week (first 3 letters), if C18 is Mon, Tue,
Wed, Thu then it will find the correct data in column D. If C18 is Fri, Sat,
Sun then no data is found UNLESS I change the first part of the vector A8:A14
to the row at least 4 days before the day being looked-up then the correct data
in column D will be found. Is there a limit to the size of the vector LOOKUP
can search? Am I attempting something LOOKUP is not designed for? I would be
grateful for any pointers.
Thanks, Steve
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
