Thread: Lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Joe is offline
external usenet poster
 
Posts: 476
Default Lookup

How do I have Excel return multiple values from a lookup in a table of
information? For example, if I have excel do a vlookup or an index/match to
the input in A1. Say A1 contains the word "Cat". I want excel to return all
the values in a table that correspond to "Cat", not just the first value it
finds.