Thread: Lookup across a Range
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bruno Campanini[_2_] Bruno Campanini[_2_] is offline
external usenet poster
  
Posts: 74
Default Lookup across a Range
Ron Rosenfeld wrote on 12-09-11 :

This formula must be **array-entered**:

=OR(A1=B3:M18)

No need of "OR":

{=(A1=B3:M18)}
FormulaArray

Bruno


Reply With QuoteReply With Quote