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