how do i combine IF and OR function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marcel - 26 Nov 2005 00:29 GMT

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?

Reply to this Message

Dave Peterson - 26 Nov 2005 01:08 GMT

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.

> Hello all I'm working on a spreadsheet with the fol formula:
> =IF(VLOOKUP(C4;Appartment!$C$1:$C$63;1;FALSE)=C4;"Double";"")
[quoted text clipped - 3 lines]
>
> is it possible?

Signature

Dave Peterson

Reply to this Message

Marcel - 28 Nov 2005 22:05 GMT

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

> Hello all I'm working on a spreadsheet with the fol formula:
> =IF(VLOOKUP(C4;Appartment!$C$1:$C$63;1;FALSE)=C4;"Double";"")
[quoted text clipped - 3 lines]
>
> is it possible?

Reply to this Message

Marcel - 28 Nov 2005 22:24 GMT

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

> I can't seem to get it to work, is there any way to use or in there
>
[quoted text clipped - 5 lines]
> >
> > is it possible?

Reply to this Message

Dave Peterson - 28 Nov 2005 22:54 GMT

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?

> if(or(isnumber(match(C4;Appartment!$C$1:$C$64;0));isnumber(match(B4;Appartment!$B$1:$B$64;0
>
[quoted text clipped - 14 lines]
> > >
> > > is it possible?

Signature

Dave Peterson

Reply to this Message

Marcel - 28 Nov 2005 23:41 GMT

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

> It worked ok for me:
>
[quoted text clipped - 23 lines]
> > > >
> > > > is it possible?

Reply to this Message