@ChemistB, doesn't that formula just return the max number? So in user's posted example, it would return 434 when he needs it to return Dog. So I imagine the Index range should be $A$1:$G$1 while the Match range should be $B$1:$H$1
@ChemistB, doesn't that formula just return the max number? So in user's posted example, it would return 434 when he needs it to return Dog. So I imagine the Index range should be $A$1:$G$1 while the Match range should be $B$1:$H$1
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks