ST Alpha - "aha. IF(ISERROR(MATCH(A3,[list],0)),"YES","NO") silly me. -- 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 "yeah, that's what charlie said too. I need to add an extra column if I do that. oh well. -- nm" by amanda

aha. IF(ISERROR(MATCH(A3,[list],0)),"YES","NO") silly me. -- nm

Posted by amanda Sep 11 '12, 12:41

(No message)

Responses:

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.