Thread: how do i combine IF and OR function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcel
 
Posts: n/a
Default how do i combine IF and OR function
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 With QuoteReply With Quote