Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
While typing a vlookup function such as "=vlookup(A2,'Sheet2'!A:A,false)",
immediately after typing the "f" in "false", Excel will crash with the following error: Identify Label There is more than one cell with this label:f Select the cell containing the label to use: [OK] [Cancel] No matter what is entered following, the following error will occur: Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience. This problem has been around for almost 5 years now. Is there a hotfix for it yet? Or should I give MS another 5 years to work on it? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
This may help as a workaround--but it's not a solution.
(xl2003 menus) Tools|Options|Calculation tab|uncheck "Accept labels in formulas" Maybe you'll be ok???? pcbins wrote: While typing a vlookup function such as "=vlookup(A2,'Sheet2'!A:A,false)", immediately after typing the "f" in "false", Excel will crash with the following error: Identify Label There is more than one cell with this label:f Select the cell containing the label to use: [OK] [Cancel] No matter what is entered following, the following error will occur: Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience. This problem has been around for almost 5 years now. Is there a hotfix for it yet? Or should I give MS another 5 years to work on it? -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
I'm not sure why everyone thinks this will fix it, but, as I tell them, this
option is not checked. I have tried it both ways, restarting excel after each change. And it makes no difference... "Dave Peterson" wrote: This may help as a workaround--but it's not a solution. (xl2003 menus) Tools|Options|Calculation tab|uncheck "Accept labels in formulas" Maybe you'll be ok???? pcbins wrote: While typing a vlookup function such as "=vlookup(A2,'Sheet2'!A:A,false)", immediately after typing the "f" in "false", Excel will crash with the following error: Identify Label There is more than one cell with this label:f Select the cell containing the label to use: [OK] [Cancel] No matter what is entered following, the following error will occur: Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience. This problem has been around for almost 5 years now. Is there a hotfix for it yet? Or should I give MS another 5 years to work on it? -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
"=vlookup(A2,'Sheet2'!A:A,false)", This formula has incomplete parameters. The Excel 2000 help file (F1) defines VLOOKUP funcation as: VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup) You are placing a boolean value (e.g. FALSE) where an integer value needs to be. To wit, you are placing your desired "range_lookup" optional value in the required "col_index_num" parameter. While FALSE can loosely be defined as zero (0) and TRUE as anything NOT FALSE, it generally isn't good practice to substitute a boolean for an integer and especially in your case as there is no ordinal column number zero (0) in a range. In your example perhaps a more appropriate formula would be: =VLOOKUP(A2,'Sheet2'!A:A,1,FALSE) HTHs |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
Sorry, that was a typo... I've been using this formula for years and years
and years... probably typed it out a thousand times or more... I know how to use the formula. Please ignore the typo above and focus on the problem... " wrote: "=vlookup(A2,'Sheet2'!A:A,false)", This formula has incomplete parameters. The Excel 2000 help file (F1) defines VLOOKUP funcation as: VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup) You are placing a boolean value (e.g. FALSE) where an integer value needs to be. To wit, you are placing your desired "range_lookup" optional value in the required "col_index_num" parameter. While FALSE can loosely be defined as zero (0) and TRUE as anything NOT FALSE, it generally isn't good practice to substitute a boolean for an integer and especially in your case as there is no ordinal column number zero (0) in a range. In your example perhaps a more appropriate formula would be: =VLOOKUP(A2,'Sheet2'!A:A,1,FALSE) HTHs |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
Since you multiposted the same question in different places, how would any one
know that you had gotten this response elsewhere? Good luck. pcbins wrote: I'm not sure why everyone thinks this will fix it, but, as I tell them, this option is not checked. I have tried it both ways, restarting excel after each change. And it makes no difference... "Dave Peterson" wrote: This may help as a workaround--but it's not a solution. (xl2003 menus) Tools|Options|Calculation tab|uncheck "Accept labels in formulas" Maybe you'll be ok???? pcbins wrote: While typing a vlookup function such as "=vlookup(A2,'Sheet2'!A:A,false)", immediately after typing the "f" in "false", Excel will crash with the following error: Identify Label There is more than one cell with this label:f Select the cell containing the label to use: [OK] [Cancel] No matter what is entered following, the following error will occur: Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience. This problem has been around for almost 5 years now. Is there a hotfix for it yet? Or should I give MS another 5 years to work on it? -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
Hi,
You table array is the entire column A (that is 65,536 rows). Please reduce the range to where your data is till and then see whether Excel still crashes. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "pcbins" wrote in message ... While typing a vlookup function such as "=vlookup(A2,'Sheet2'!A:A,false)", immediately after typing the "f" in "false", Excel will crash with the following error: Identify Label There is more than one cell with this label:f Select the cell containing the label to use: [OK] [Cancel] No matter what is entered following, the following error will occur: Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience. This problem has been around for almost 5 years now. Is there a hotfix for it yet? Or should I give MS another 5 years to work on it? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
No, it doesnt matter what size the array is. It is rarely the entire column.
RARELY EVER. It can be 500 rows or 5000 or 50000. It makes no difference. PLEASE ADDRESS THE PROBLEM, MICROSOFT, and provide a fix. I think 5 years is long enough to have researched it. "Ashish Mathur" wrote: Hi, You table array is the entire column A (that is 65,536 rows). Please reduce the range to where your data is till and then see whether Excel still crashes. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "pcbins" wrote in message ... While typing a vlookup function such as "=vlookup(A2,'Sheet2'!A:A,false)", immediately after typing the "f" in "false", Excel will crash with the following error: Identify Label There is more than one cell with this label:f Select the cell containing the label to use: [OK] [Cancel] No matter what is entered following, the following error will occur: Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience. This problem has been around for almost 5 years now. Is there a hotfix for it yet? Or should I give MS another 5 years to work on it? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
Nevermind, I think I will repost without an example so you can focus on the
real problem... "Ashish Mathur" wrote: Hi, You table array is the entire column A (that is 65,536 rows). Please reduce the range to where your data is till and then see whether Excel still crashes. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "pcbins" wrote in message ... While typing a vlookup function such as "=vlookup(A2,'Sheet2'!A:A,false)", immediately after typing the "f" in "false", Excel will crash with the following error: Identify Label There is more than one cell with this label:f Select the cell containing the label to use: [OK] [Cancel] No matter what is entered following, the following error will occur: Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience. This problem has been around for almost 5 years now. Is there a hotfix for it yet? Or should I give MS another 5 years to work on it? |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
pcbins wrote:
No, it doesnt matter what size the array is. It is rarely the entire column. RARELY EVER. It can be 500 rows or 5000 or 50000. It makes no difference. PLEASE ADDRESS THE PROBLEM, MICROSOFT, and provide a fix. I think 5 years is long enough to have researched it. Does this happen in any worksheet you try it in, or only a specific worksheet? I can't duplicate the problem. By the way, you may have mistakenly assumed that you are talking to MICROSOFT EMPLOYEES...the people here, even the MVP's, are volunteers, not generally affiliated with Microsoft. |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
These groups are peer-newsgroups, not official channels for MS. Nobody
here can fix your problem, assuming it exists. Frankly, given that it, as far as I can tell, has never come up in these groups before, I suspect it's something unique to your system. Otherwise, there would have been an outcry from millions of users who use VLOOKUP. In article , pcbins wrote: PLEASE ADDRESS THE PROBLEM, MICROSOFT, and provide a fix. I think 5 years is long enough to have researched it. |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
try Googling it... I accidentally found this "lets help each other since
microsoft won't" forum... millions are out there not knowing where to go for help when microsoft ignores them... "JE McGimpsey" wrote: These groups are peer-newsgroups, not official channels for MS. Nobody here can fix your problem, assuming it exists. Frankly, given that it, as far as I can tell, has never come up in these groups before, I suspect it's something unique to your system. Otherwise, there would have been an outcry from millions of users who use VLOOKUP. In article , pcbins wrote: PLEASE ADDRESS THE PROBLEM, MICROSOFT, and provide a fix. I think 5 years is long enough to have researched it. |
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
In article ,
pcbins wrote: try Googling it... I accidentally found this "lets help each other since microsoft won't" forum... millions are out there not knowing where to go for help when microsoft ignores them... I had checked Google groups, and I've just googled ("VLOOKUP crash FALSE"). Prior to this month, there's nothing relevant back through 2003. I don't want to be an MS apologist, but if there were really millions of people having this problem, we would have heard about it here. That doesn't mean that the problem isn't real - just not very common. |
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
JE McGimpsey wrote:
In article , pcbins wrote: try Googling it... I accidentally found this "lets help each other since microsoft won't" forum... millions are out there not knowing where to go for help when microsoft ignores them... I had checked Google groups, and I've just googled ("VLOOKUP crash FALSE"). Prior to this month, there's nothing relevant back through 2003. I don't want to be an MS apologist, but if there were really millions of people having this problem, we would have heard about it here. That doesn't mean that the problem isn't real - just not very common. http://tinyurl.com/bbq9kn |
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
oh my goodness! you are kidding me? Are you sure you are using Google?? I get
pages and pages... "JE McGimpsey" wrote: In article , pcbins wrote: try Googling it... I accidentally found this "lets help each other since microsoft won't" forum... millions are out there not knowing where to go for help when microsoft ignores them... I had checked Google groups, and I've just googled ("VLOOKUP crash FALSE"). Prior to this month, there's nothing relevant back through 2003. I don't want to be an MS apologist, but if there were really millions of people having this problem, we would have heard about it here. That doesn't mean that the problem isn't real - just not very common. |
#16
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
In article ,
Glenn wrote: http://tinyurl.com/bbq9kn Hmmm.. OK. Didn't show up in http://tinyurl.com/azb7f7 Still, 1 thread (in 2004) doesn't a million make. |
#17
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
In article ,
pcbins wrote: oh my goodness! you are kidding me? Are you sure you are using Google?? I get pages and pages... I get pages and pages of results for that search, but only a few that mention crashing when typing the 'f' in False - and at least one was XL02, not X03. I'm not really interested in continuing the search, and I'm not trying to be a net nanny. It's obviously a real problem for at least a few people, but AFAIK, there's been no solutions posted anywhere. If someone happens to have a solution, I'm sure they'll post it. |
#18
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
If you've found pages and pages, why not give us the url of your Google
search? -- David Biddulph "pcbins" wrote in message ... oh my goodness! you are kidding me? Are you sure you are using Google?? I get pages and pages... "JE McGimpsey" wrote: In article , pcbins wrote: try Googling it... I accidentally found this "lets help each other since microsoft won't" forum... millions are out there not knowing where to go for help when microsoft ignores them... I had checked Google groups, and I've just googled ("VLOOKUP crash FALSE"). Prior to this month, there's nothing relevant back through 2003. I don't want to be an MS apologist, but if there were really millions of people having this problem, we would have heard about it here. That doesn't mean that the problem isn't real - just not very common. |
#19
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel crashes when typing "false" in VLookup function
JE McGimpsey wrote:
In article , pcbins wrote: oh my goodness! you are kidding me? Are you sure you are using Google?? I get pages and pages... I get pages and pages of results for that search, but only a few that mention crashing when typing the 'f' in False - and at least one was XL02, not X03. I'm not really interested in continuing the search, and I'm not trying to be a net nanny. It's obviously a real problem for at least a few people, but AFAIK, there's been no solutions posted anywhere. If someone happens to have a solution, I'm sure they'll post it. The only "solution" posted seems to have been to use a zero instead of typing "false". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VLookup crash when typing "false" | Excel Discussion (Misc queries) | |||
=IF(VLOOKUP(C11,Group,2,FALSE)=D11,"True","Not Valid") and =IF(D1 | Excel Worksheet Functions | |||
vlookup if statement returning a "false" answer. | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |