Thread: Lookup across columns
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lori Lori is offline
external usenet poster
  
Posts: 340
Default Lookup across columns
If data is in Sheet1 and lookup values are in cell A1 downwards, try
filling down this:

=COUNTIF(Sheet1!A:E,A1)0

Reply With QuoteReply With Quote