Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi. I use VLOOKUP formula's every single day - I use them A LOT !
My current machine has Ms Excel 2003. A normal Vlookup formula looks like : =VLOOKUP(A2,Sheet1!$A$16:$B$21,16,FALSE) Prior to Ms Excel 2003, I have NEVER had a problem with Vlookup formula's. HOWEVER.....Some "Genius" Programmer at Excel has bugged the Worksheet command. Now, when I go to type "FALSE" at the end of a Vlookup command, Excel suddenly opens a Dialog Box looking to "Identify Label".... If I try to close this box or cancel it - Excel crashes with the loss of all unsaved work. There does not seem to be any means of turning this damned function off either. It seems to me a classic case of somebody trying to 'Fix' Excel when it's not broken. PLEASE PLEASE....If there's any download, bug fix or <ANYTHING I can do to stop this damned dialog box opening up and crashing Excel - I would LOVE to know what it is. Thanks, A. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Forumla (vlookup problem) | Excel Discussion (Misc queries) | |||
My Y-axis label is cut off in Excel charts | Charts and Charting in Excel | |||
why is the y-axis label in the Excel graph always messed up? | Charts and Charting in Excel | |||
Excel graph y axis label cut | Charts and Charting in Excel | |||
Excel crashing when typing VLOOKUP | Excel Discussion (Misc queries) |