Hi,
In the attached Sample file, I am trying to lookup the values in Column B "Color" when I filter the column A "Name" with the corresponding value.
For ex: in the file, when I filter Column A for "aaa" I should only see "Black, yellow, red".
Is there a way to do this?
Thanks in advance
Vijay
Bookmarks