Hi all,

I'm trying to set up a record sheet of sorts that would have various record categories automatically picking out the proper values from another sheet. I've found that the MAX function works great for this, but I need information from neighboring cells as well.

For instance... on the sheet of data that the records are picking from, there will be three columns, one for team, one for name and one for number of points. I can use MAX to search through all the people listed and get the highest number of points, but I'd like to have the data accompanied with the person's name and team if possible.

Hopefully that makes sense... any help is appreciated. I'm running Excel 07... Thanks!