close

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
quot;attachingquot; 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 quot;unorganizedquot;. Another problem I am running in to is
that I can't quot;assignquot; 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


check out this site, it's just what you are looking forthis shows how to use VLOOKUP

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

www.contextures.com/xlNames01.html#Dynamic--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=539144

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()