This should be pretty easy for anyone who knows what they're doing, for me its a bit hard. I've attached the small file to make it easier to conceptualize.
I have a list of numbers in A1:A28.
I want to see if the number in D1 is in that list. So in D2 I wrote this formula:
=IF(A1:A28=D1,"YES","NO")
I'm always getting a no tho. Why would that be?
Fil.xlsx
Perhaps
Please Login or Register to view this content.
Hi
Working on an answer for you that will work but looking at your formula A1:A28 would all have to have the same value as D1 to get a yes.
Chris
Click my star if I helped Thanks
really?Originally Posted by dogberry
basically i just want a yes if D1 is in the list somewhere.
Hi
I think you have been given the solution by Pepe
Chris
Yes just tried it and it works.
C
Last edited by dogberry; 11-13-2012 at 04:11 PM.
Another way
=IF(ISNUMBER(MATCH(D1,A1:A28,0)),"Yes","No")
Life's a spreadsheet, Excel!
Say thanks, Click *
Forgot the referencesPlease Login or Register to view this content.
that worked, thanks Pepe! as well as Ace & Dogberry for making the effort.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks