how do i combine IF and OR function

M

Marcel

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

Dave Peterson

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))),"double","")

(all one cell)

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

Marcel

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
 
D

Dave Peterson

It worked ok for me:

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

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

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

Marcel

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

Dave Peterson said:
It worked ok for me:

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

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

If that doesn't help, what kind of error do you get?
Click to expand...
 
Top