Function neede which checks if a value in a cell is in a defined s

L

LastPhilippe

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?
 
L

Luke M

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.
 
M

Marcelo

see if copy and paste special transpose

solve it

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"LastPhilippe" escreveu:
 
M

Marcelo

sorry I have posted it wrong
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marcelo" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to look up value in another Sheet based on criteria in first sheet. 1
selecting cells and getting their content into a string? 1
IF function (copy cell) in a macro 4
Syntax for 'search' in Horizontal range? XL2007 2
Can i use If to check if a cell is equal to any value in a particular range 1
VBA: Matching cells across columns, and returning equal values 0
What is the math behind array function 2
Creating task in outlook from a particular row in excel 1

Top