I need a formula!!Ahhhh!
 

I have killed myself for the last two days on this one. I am yet a newbie to
Excel so you may laugh.
I have a column of names and a cloumn of scores. I need to find a way of
"attaching" each name to it's specific score...For example: Michael Jordan
has a score of 23. Mike Bibby has a score of 20. So on and so on. I already
have the coulmns of names and the coulmn of scores. Now, I need to make a
list like this of two columns that are Alphabetically Ordered aside from the
other two columns of "unorganized". Another problem I am running in to is
that I can't "assign" the score to the player....If I move the player/name.
The score does not follow. Thus making it impossible to add more names to the
list.
I appreciat all responses.
Thank you-Levi

I need a formula!!Ahhhh!
 

check out this site, it's just what you are looking for


this shows how to use VLOOKUP

http://www.contextures.com/xlFunctions02.html

This shows how to add names to a list, which you could then use for a
dropdown menu in your vlookup

http://www.contextures.com/xlNames01.html#Dynamic


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=539144