Log In
Create Account
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
Links Only
50 Results
100 Results
250 Results
500 Results
1000 Results
5000 Results
2 Weeks
2 Months
6 Months
1 Year
2 Years
5 Years
All Time
Live
Down to Post
Backboards:
Live
________________
1: Dec 2, 17:22
2: Dec 2, 11:48
3: Dec 2, 08:21
4: Dec 1, 17:33
5: Dec 1, 11:23
6: Nov 30, 15:54
7: Nov 30, 09:41
8: Nov 29, 16:44
9: Nov 29, 08:01
10: Nov 28, 16:19
11: Nov 28, 09:42
12: Nov 27, 18:07
13: Nov 27, 12:04
14: Nov 27, 08:26
15: Nov 26, 18:06
16: Nov 26, 12:05
17: Nov 26, 08:29
18: Nov 25, 18:33
19: Nov 25, 11:12
20: Nov 25, 07:08
Posts: 157
In response to
"
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
"
by
amanda
use vlookup -- nm
Posted by
decline (aka Decline)
Sep 11 '12, 12:32
(No message)
Responses:
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.
