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?