A simple task that I just can't get to work...

I have a simmple table in which I enter a number in a cell. I then
want to LOOKUP this number and if it matches what I am looking for I
want to return "1" if not return "0"

eg

A B
636 1
658 0
659 0
624 1
632 0

using the above table I want to look up the numbers in column A in a
seperate table and if it in the lookup table, return "1" if not "0"
the lookup table has

624 1
636 1
637 1
660 1

I got Vlookup to work but if the number is not in my lookup table I
get an #N/A returned which I don't want


Any suggestions would be helpfull or a better idea I'd br gratefull

G..

Hy G..

try following:

=if(iserror(YOURVLOOKUPFORMULA),0,1)

hth
Carlo

On Jan 17, 9:55*am, wrote:
A simple task that I just can't get to work...

I have a simmple table in which I enter a number in a cell. I then
want to LOOKUP this number and if it matches what I am looking for I
want to return "1" if not *return "0"

eg

A * * * B
636 * * 1
658 * * 0
659 * * 0
624 * * 1
632 * * 0

using the above table I want to look up the numbers in column A in a
seperate table and if it in the lookup table, return "1" if not "0"
the lookup table has

624 * * 1
636 * * 1
637 * * 1
660 * * 1

I got Vlookup to work but if the number is not in my lookup table I
get an #N/A returned which I don't want

Any suggestions would be helpfull or a better idea I'd br gratefull

G..

=--isnumber(match(a1,sheet2!a:a,0))

=isnumber() will return true or false.
the two minus signs will convert true to 1 and false to 0.

wrote:

A simple task that I just can't get to work...

I have a simmple table in which I enter a number in a cell. I then
want to LOOKUP this number and if it matches what I am looking for I
want to return "1" if not return "0"

eg

A B
636 1
658 0
659 0
624 1
632 0

using the above table I want to look up the numbers in column A in a
seperate table and if it in the lookup table, return "1" if not "0"
the lookup table has

624 1
636 1
637 1
660 1

I got Vlookup to work but if the number is not in my lookup table I
get an #N/A returned which I don't want

Any suggestions would be helpfull or a better idea I'd br gratefull

G..

--

Dave Peterson

=(COUNTIF(LookupTable,A1)0)+0


" wrote:

A simple task that I just can't get to work...

I have a simmple table in which I enter a number in a cell. I then
want to LOOKUP this number and if it matches what I am looking for I
want to return "1" if not return "0"

eg

A B
636 1
658 0
659 0
624 1
632 0

using the above table I want to look up the numbers in column A in a
seperate table and if it in the lookup table, return "1" if not "0"
the lookup table has

624 1
636 1
637 1
660 1

I got Vlookup to work but if the number is not in my lookup table I
get an #N/A returned which I don't want


Any suggestions would be helpfull or a better idea I'd br gratefull

G..

Thanks all,

I will give them all a go just for my edification.

Should be able to get one to work :)



G..