Thread: Recalling ranks from a matrix using vlookup & hlookup

Hi guys I’m new to excel and this forum and I am working on a spreadsheet that can recall the top 3 rankings of interactions between people in a matrix questionnaire.

For example, I sent the questionnaire to each person and they are ranking who they interact with the most - 1 being the heights level of interaction and 3 being the lowest. (see image) The ranking is done up and down and the score are taken across. The lower the score across the matrix the higher interactions they have.

http://i1017.photobucket.com/albums/.../excelrank.png

Now, I want to recall each person’s #1, #2 & #3 from the matrix and automatically populate it into a list like the one below (see image). I would want to automatically fill in B9:D12 from the matrix above.

http://i1017.photobucket.com/albums/...excelrank2.png

I actually have a 28x28 matrix that needs to rank the top 5 to 7 but I’m using this as an example. I tried to use vlookup, hlookup, and rank functions but I wasn’t able to make it work
Thanks in advance

Thank you very much it worked!

One more questions - say I were to ask them to rank games. Now A2 to A5 would change to baseball, basketball, soccer, football. B2 to E2 would stay the same with monica, chris, john, peter. How can I change the formuala to work with different things listed across from that ones listed up and down?