J
Joe
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.
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.