LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #17   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,240
Default 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".
 
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
Excel VLookup crash when typing "false" pcbins Excel Discussion (Misc queries) 2 January 29th 09 07:14 PM
=IF(VLOOKUP(C11,Group,2,FALSE)=D11,"True","Not Valid") and =IF(D1 Milky Excel Worksheet Functions 1 August 20th 08 08:38 PM
vlookup if statement returning a "false" answer. inthestands Excel Worksheet Functions 2 September 20th 07 11:36 PM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM


All times are GMT +1. The time now is 10:26 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"