LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stop renaming or moving sheet tabs sparx Excel Discussion (Misc queries) 9 May 16th 06 08:44 PM
Shorten a Macro mully Excel Discussion (Misc queries) 7 December 30th 05 05:52 PM
Inconsistent Macro Behavior Sarah K Excel Discussion (Misc queries) 4 November 1st 05 10:36 PM
Grouped Sheets and Formating Pank Mehta Excel Discussion (Misc queries) 3 March 24th 05 01:42 AM
Grand Totals @ Same Place Amber M Excel Worksheet Functions 2 December 30th 04 07:13 PM


All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"