how do i combine IF and OR function
 

Hello all I'm working on a spreadsheet with the fol formula:
=IF(VLOOKUP(C4;Appartment!$C$1:$C$63;1;FALSE)=C4;" Double";"")

I would like to and an OR in there that it would lookup and other columie:
(B4;Appartment!$B$1:$B$63;1;FALSE)=B4;"Double";"") .

is it possible?

how do i combine IF and OR function
 

Since your table is only one column wide, you could use =match() to look for,
er, a match.

=if(or(isnumber(match(c4,appartment!$c$1:$c63,0)),
isnumber(match(b4,appartment!$b$1:$b$63,0))),"doub le","")

(all one cell)

=match() returns a number if there's a match.

Marcel wrote:

Hello all I'm working on a spreadsheet with the fol formula:
=IF(VLOOKUP(C4;Appartment!$C$1:$C$63;1;FALSE)=C4;" Double";"")

I would like to and an OR in there that it would lookup and other columie:
(B4;Appartment!$B$1:$B$63;1;FALSE)=B4;"Double";"") .

is it possible?

--

Dave Peterson

how do i combine IF and OR function
 

I can't seem to get it to work, is there any way to use or in there

"Marcel" wrote:

Hello all I'm working on a spreadsheet with the fol formula:
=IF(VLOOKUP(C4;Appartment!$C$1:$C$63;1;FALSE)=C4;" Double";"")

I would like to and an OR in there that it would lookup and other columie:
(B4;Appartment!$B$1:$B$63;1;FALSE)=B4;"Double";"") .

is it possible?

how do i combine IF and OR function
 

if(or(isnumber(match(C4;Appartment!$C$1:$C$64;0)); isnumber(match(B4;Appartment!$B$1:$B$64;0

Ok i found sone of the trouble with it: but i still get and error for the
lasrt part of it

)));"Double","")

Help
"Marcel" wrote:

I can't seem to get it to work, is there any way to use or in there

"Marcel" wrote:

Hello all I'm working on a spreadsheet with the fol formula:
=IF(VLOOKUP(C4;Appartment!$C$1:$C$63;1;FALSE)=C4;" Double";"")

I would like to and an OR in there that it would lookup and other columie:
(B4;Appartment!$B$1:$B$63;1;FALSE)=B4;"Double";"") .

is it possible?

how do i combine IF and OR function
 

It worked ok for me:

=IF(OR(ISNUMBER(MATCH(C4;appartment!$C$1:$C63;0));
ISNUMBER(MATCH(B4;appartment!$B$1:$B$63;0)));"doub le";"")

(I think I got all the commas converted to semicolons)

If that doesn't help, what kind of error do you get?

Marcel wrote:

if(or(isnumber(match(C4;Appartment!$C$1:$C$64;0)); isnumber(match(B4;Appartment!$B$1:$B$64;0

Ok i found sone of the trouble with it: but i still get and error for the
lasrt part of it

)));"Double","")

Help
"Marcel" wrote:

I can't seem to get it to work, is there any way to use or in there

"Marcel" wrote:

Hello all I'm working on a spreadsheet with the fol formula:
=IF(VLOOKUP(C4;Appartment!$C$1:$C$63;1;FALSE)=C4;" Double";"")

I would like to and an OR in there that it would lookup and other columie:
(B4;Appartment!$B$1:$B$63;1;FALSE)=B4;"Double";"") .

is it possible?




--

Dave Peterson

how do i combine IF and OR function
 

it's seem like it's working now Thanks Dave

"Dave Peterson" wrote:

It worked ok for me:

=IF(OR(ISNUMBER(MATCH(C4;appartment!$C$1:$C63;0));
ISNUMBER(MATCH(B4;appartment!$B$1:$B$63;0)));"doub le";"")

(I think I got all the commas converted to semicolons)

If that doesn't help, what kind of error do you get?

Marcel wrote:

if(or(isnumber(match(C4;Appartment!$C$1:$C$64;0)); isnumber(match(B4;Appartment!$B$1:$B$64;0

Ok i found sone of the trouble with it: but i still get and error for the
lasrt part of it

)));"Double","")

Help
"Marcel" wrote:

I can't seem to get it to work, is there any way to use or in there

"Marcel" wrote:

Hello all I'm working on a spreadsheet with the fol formula:
=IF(VLOOKUP(C4;Appartment!$C$1:$C$63;1;FALSE)=C4;" Double";"")

I would like to and an OR in there that it would lookup and other columie:
(B4;Appartment!$B$1:$B$63;1;FALSE)=B4;"Double";"") .

is it possible?




--

Dave Peterson