ST Alpha - "I misspoke, sorry. if it's in a range of cells. like if a1 is in the list c1:c100, return 1. sorry, thank youo. -- nm" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 157

In response to "if( AND ( x > low , x < high) , 1 , 2) -- nm" by decline

I misspoke, sorry. if it's in a range of cells. like if a1 is in the list c1:c100, return 1. sorry, thank youo. -- nm

Posted by amanda Sep 11 '12, 12:30

(No message)

Responses:

use vlookup -- nm - decline Sep 11, 12:32 7
- yeah, that's what charlie said too. I need to add an extra column if I do that. oh well. -- nm - amanda Sep 11, 12:34 6
  - aha. IF(ISERROR(MATCH(A3,[list],0)),"YES","NO") silly me. -- nm - amanda Sep 11, 12:41 5
    - I [heart] iserror to fix problems with vlookup. - spamlet Sep 11, 12:45 4
      - thanks to everyone who helped. note that the issue was not formula, but buttheadism: I forgot to anchor my range. - amanda Sep 11, 12:48 3
        
        oops! -- nm - znufrii Sep 11, 12:58
        
        That's the worst. At least you realized it quickly. -- nm - spamlet Sep 11, 12:53 1
        
        (I'll never admit it to charlie, obvs.) - amanda Sep 11, 12:54

Post a message top

Replies are disabled on threads older than 7 days.