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