Hi All,

I am looking at this website to figure out a problem that I have. (Trying to figure out what names go with each animal). The example they show, enables you to drap and drop across the column. I want to do the opposite and drap and drop across the rows, so that I could look up multiple different animals and see the names across the rows. You could to this on columns, but since I have alot of names its easier for me to view this on the row level if that makes sense.

Any ideas of how to manipulate the forumla, to do this?

http://thinketg.com/how-to-return-mu...ch-or-vlookup/

Current Formula
=IF(ISERROR(INDEX($A$1:$B$8,SMALL(IF($A$1:$A$8=$E$1,ROW($A$1:$A$8)),ROW(1:1)),2)),"",INDEX($A$1:$B$8,SMALL(IF($A$1:$A$8=$E$1,ROW($A$1:$A$8)),ROW(1:1)),2))