Thread: Excel'03 crashes with VLOOKUPS ending in FALSE

I'm an experienced Excel user - I've recently upgraded machine, which has
meant upgrading from Excel 2000 to Excel 2003.

I use the VLOOKUP commands *a lot* with my job.

I see that Excel 2003 now has the option to use Text labels (e.g "Sales",
etc) instead of cell references (e.g $A$3).

I only ever use Cell references, because I find it easier to work with,
easier to spot if something goes wrong, etc.

Since upgrading to Excel 2003, VLOOKUPS have started failing to work
properly.

Example :

=VLOOKUP($D6,[Book2]Sheet1!$D$7:$G$11,2,

I can get as far into the formula as this...but when I want to type "FALSE)"
and hit enter, I get a dialogue box open up saying "Identify Label".

When I click on the 'X' to close this dialogue box, Excel promptly crashes
- every single time.

What's more, I've note been able to find a means of turning off this damned
"Identify Label" function.

It's a classic case of "If it aint broken - Don't fix it !".

Anyone have any tips on how I can permanently turn this annoying new
function off, I'd be very grateful..

Thanks,
Andy.

=VLOOKUP($D6,[Book2]Sheet1!$D$7:$G$11,2,0)


--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"andy_suffers_Excel_2003_over-engineering"
<andy_suffers_Excel_2003_over-engineering@discussions.microsoft.com> wrote
in message news:64F7F939-90B9-4E8D-97B9-19A3BDAF059C@microsoft.com...
> I'm an experienced Excel user - I've recently upgraded machine, which has
> meant upgrading from Excel 2000 to Excel 2003.
>
> I use the VLOOKUP commands *a lot* with my job.
>
> I see that Excel 2003 now has the option to use Text labels (e.g "Sales",
> etc) instead of cell references (e.g $A$3).
>
> I only ever use Cell references, because I find it easier to work with,
> easier to spot if something goes wrong, etc.
>
> Since upgrading to Excel 2003, VLOOKUPS have started failing to work
> properly.
>
> Example :
>
> =VLOOKUP($D6,[Book2]Sheet1!$D$7:$G$11,2,
>
> I can get as far into the formula as this...but when I want to type
> "FALSE)"
> and hit enter, I get a dialogue box open up saying "Identify Label".
>
> When I click on the 'X' to close this dialogue box, Excel promptly
> crashes
> - every single time.
>
> What's more, I've note been able to find a means of turning off this
> damned
> "Identify Label" function.
>
> It's a classic case of "If it aint broken - Don't fix it !".
>
> Anyone have any tips on how I can permanently turn this annoying new
> function off, I'd be very grateful..
>
> Thanks,
> Andy.

Do you mean Tools / Options / Calculation Tab / 'Accept labels in Formulas'?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"andy_suffers_Excel_2003_over-engineering"
<andy_suffers_Excel_2003_over-engineering@discussions.microsoft.com> wrote
in message news:64F7F939-90B9-4E8D-97B9-19A3BDAF059C@microsoft.com...
> I'm an experienced Excel user - I've recently upgraded machine, which has
> meant upgrading from Excel 2000 to Excel 2003.
>
> I use the VLOOKUP commands *a lot* with my job.
>
> I see that Excel 2003 now has the option to use Text labels (e.g "Sales",
> etc) instead of cell references (e.g $A$3).
>
> I only ever use Cell references, because I find it easier to work with,
> easier to spot if something goes wrong, etc.
>
> Since upgrading to Excel 2003, VLOOKUPS have started failing to work
> properly.
>
> Example :
>
> =VLOOKUP($D6,[Book2]Sheet1!$D$7:$G$11,2,
>
> I can get as far into the formula as this...but when I want to type
> "FALSE)"
> and hit enter, I get a dialogue box open up saying "Identify Label".
>
> When I click on the 'X' to close this dialogue box, Excel promptly
> crashes
> - every single time.
>
> What's more, I've note been able to find a means of turning off this
> damned
> "Identify Label" function.
>
> It's a classic case of "If it aint broken - Don't fix it !".
>
> Anyone have any tips on how I can permanently turn this annoying new
> function off, I'd be very grateful..
>
> Thanks,
> Andy.

BTW, for the OP. This option is also available in 2000 (I am using 2000 and
just checked.) I wonder if maybe it is turned on default in 2003, or maybe
whoever set up the installation turned this option on?
--
Kevin Vaughn


"Ken Wright" wrote:

> Do you mean Tools / Options / Calculation Tab / 'Accept labels in Formulas'?
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ------------------------------Â*------------------------------Â*----------------
> It's easier to beg forgiveness than ask permission :-)
> ------------------------------Â*------------------------------Â*----------------
>
>
> "andy_suffers_Excel_2003_over-engineering"
> <andy_suffers_Excel_2003_over-engineering@discussions.microsoft.com> wrote
> in message news:64F7F939-90B9-4E8D-97B9-19A3BDAF059C@microsoft.com...
> > I'm an experienced Excel user - I've recently upgraded machine, which has
> > meant upgrading from Excel 2000 to Excel 2003.
> >
> > I use the VLOOKUP commands *a lot* with my job.
> >
> > I see that Excel 2003 now has the option to use Text labels (e.g "Sales",
> > etc) instead of cell references (e.g $A$3).
> >
> > I only ever use Cell references, because I find it easier to work with,
> > easier to spot if something goes wrong, etc.
> >
> > Since upgrading to Excel 2003, VLOOKUPS have started failing to work
> > properly.
> >
> > Example :
> >
> > =VLOOKUP($D6,[Book2]Sheet1!$D$7:$G$11,2,
> >
> > I can get as far into the formula as this...but when I want to type
> > "FALSE)"
> > and hit enter, I get a dialogue box open up saying "Identify Label".
> >
> > When I click on the 'X' to close this dialogue box, Excel promptly
> > crashes
> > - every single time.
> >
> > What's more, I've note been able to find a means of turning off this
> > damned
> > "Identify Label" function.
> >
> > It's a classic case of "If it aint broken - Don't fix it !".
> >
> > Anyone have any tips on how I can permanently turn this annoying new
> > function off, I'd be very grateful..
> >
> > Thanks,
> > Andy.
>
>
>