Looking for Easier Formula
Posted by Kevin on February 04, 2002 8:54 PM
I have a list of ten names (let's say in cells a1 thru a10). Each name has certain data associated only with that name. I want to be able to select a few names by placing a 1,2 and 3 next to their names (say in b1 thru b10). I then want three other cells to look at b1 thru b10 and compute a formula based upon the finding of a 1,2 or 3 . Can anyone hlep me with this? If I need to provide more clarity let me know.