Hi there!
I hope the subject was clear, but here's my situation:
Name 1 Volume 1 Name 2 Volume 2 Name 3 Volume 3 Winning Name
A 100 B 200 DD 400 DD
big 100 brown 20 cat 15 big
ORANGE 0 BLACK 2000 BLUE 50 BLACK
-except that there are also columns Name 4 and Volume 4 between columns Volume 3 and Winning Name
-The Upperleft cell Name 1 is on cell C2
What I've been trying to do without any success so far ( ) is to insert a formula in column K (Winning Name) that would give me the Name that has the highest Volume. This is as shown on the table above under column Winning Name.
I'm not very skilled in excel but the formula (I think it's going to be HLOOKUP) should be something on the lines of this: http://answers.yahoo.com/question/in...4031032AABaYjB
I'd be very grateful for the formula I need!
Thank you so much!!
Bookmarks