Re: Combining ISNA and LEN functions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Flats (Flats.12uhqk_at_excelforum-nospam.com)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 03:50:46 -0600

Hi,

Thanks for the quick response, unfortunately there seems to be a
problem. When the 'player' exists it works fine and returns either a
value or a blank.

However when the 'player' did not exist (ie didn't play that game) I'm
still getting #N/A

In the cell where the player didn't exist if I press the fx button,
to open the function Arguements box, the logical_test says this :

OR(ISNA(VLOOKUP($A8,'Game 1'!$A$4:$N$11,12,0)),LEN(VLOOKUP($A8,'Game
1'!$A$4:$N$11,12,0))=0)

= #N/A (ie not a TRUE or FALSE)

is there a problem with the syntax?

Thanks in advance 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • Re: Chaos in the hard court GOAT ranks!
    ... The *way* Nalby beat everybody at Madrid+paris 2007 was the main reason. ... dominated at first and then Fed caught and passed him), Federer has ... response on what do you do against a player who is in the zone. ...
    (rec.sport.tennis)
  • Re: Online poker Theory
    ... I have played poker at a B&M. ... I'm just a recreational player BUT I do like to make money. ... > distractions, and I find the level of play, online, to be horrible. ... > wanted to see an intelligent response. ...
    (rec.gambling.poker)
  • Re: Not in list requery issue
    ... If I enter Player as a last name, I get prompted for the new record ... know thy limits....know thy newsgroups! ... Response As Integer) ... Response = acDataErrContinue ...
    (microsoft.public.access.formscoding)
  • Re: WoW forums - -mean?
    ... trouble understanding what they are saying. ... Some of the posts are downright creepy and some ... A new player asks a question and Mr 'I play 24 hours a day and pwn all' ... coolest thing on the planet for his response. ...
    (alt.games.warcraft)
  • Re: Not in list requery issue
    ... If I enter Player as a last name, I get prompted for the new record ... know thy limits....know thy newsgroups! ... Setting the Response variable to acDataErrAdded should automatically cause a requery of the control. ... Response = acDataErrContinue ...
    (microsoft.public.access.formscoding)