 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008Function neede which checks if a value in a cell is in a defined s
Hello, example: I have a row where can be the names of animals: cow, cat, dog, frog, ... To analyse the content against some special values, eg. pets(cat, dog), I need a function which returns true (or 1) and false (or 0): is_in_set(b$2$;pets) or is_in_set(b$2$;(cat,dog)) Any idea?  SignatureLastPhilippe Johannes Sounds like you could use some sort of VLOOKUP, and if it returns an error, you would know the item was not in your list of pets. =IF(ISERROR(VLOOKUP(B2,D1:D10,1,FALSE)),0,1) Where D1:D10 is where your list is. SignatureBest Regards, Luke M > Hello, > [quoted text clipped - 7 lines] > > Any idea? see if copy and paste special transpose solve it hth Signatureregards from Brazil Thanks in advance for your feedback. Marcelo > Hello, > [quoted text clipped - 7 lines] > > Any idea? sorry I have posted it wrong Signatureregards from Brazil Thanks in advance for your feedback. Marcelo > see if copy and paste special transpose > [quoted text clipped - 13 lines] > > > > Any idea? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.