software

I have a data sheet that contains a list of footballers (soccer) names
(i4:i35). Each time they score a goal i enter a 1 by the side of there
name, then a 2 when they get a second etc. In a second data sheet i use
data validation to allow people to choose anyone of these players eg
ab4= the list of players. When a player scores i want their number of
goals to appear in this second sheet eg in ac4, but obviously this
depends on which player has been chosen from the list in ab4. I have
tried using if statements within if statements but you can only have a
maximum of 7 'ifs' eg
=if(ab4=quot;johnquot;,$j$4,if(ab4=quot;danquot;,$j$5,if(ab4=quot;ronquot; ,$j$6,0))). I have
tried using Vlookup by doing =VLOOKUP(AB4,i4:i35,2) where the goals
scored are my second column and when i choose the first person in the
list in ab4 the value that is returned in ac4 is 0 when it should be 1
since this is what i entered in j4, please help!!! -------------------------------------------------------------------
|Filename: Copy of World Cup 2006.zip |
|Download: www.excelforum.com/attachment.php?postid=4770 |
-------------------------------------------------------------------

--
Blade2304
------------------------------------------------------------------------
Blade2304's Profile: www.excelforum.com/member.php...oamp;userid=33492
View this thread: www.excelforum.com/showthread...hreadid=542610It seems to me your biggest problem is that in your look up range, you are
only referencing 1 column, but trying to get information from the second
column (j)
But I would also add a false argument so that it would find exact matches.
Something like this (note, I used A4 instead of AB4 as I didn't really want
to scroll all the way ...)

=VLOOKUP(A4,I4:J35,2,FALSE)

--
Kevin Vaughnquot;Blade2304quot; wrote:

gt;
gt; I have a data sheet that contains a list of footballers (soccer) names
gt; (i4:i35). Each time they score a goal i enter a 1 by the side of there
gt; name, then a 2 when they get a second etc. In a second data sheet i use
gt; data validation to allow people to choose anyone of these players eg
gt; ab4= the list of players. When a player scores i want their number of
gt; goals to appear in this second sheet eg in ac4, but obviously this
gt; depends on which player has been chosen from the list in ab4. I have
gt; tried using if statements within if statements but you can only have a
gt; maximum of 7 'ifs' eg
gt; =if(ab4=quot;johnquot;,$j$4,if(ab4=quot;danquot;,$j$5,if(ab4=quot;ronquot; ,$j$6,0))). I have
gt; tried using Vlookup by doing =VLOOKUP(AB4,i4:i35,2) where the goals
gt; scored are my second column and when i choose the first person in the
gt; list in ab4 the value that is returned in ac4 is 0 when it should be 1
gt; since this is what i entered in j4, please help!!!
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: Copy of World Cup 2006.zip |
gt; |Download: www.excelforum.com/attachment.php?postid=4770 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; Blade2304
gt; ------------------------------------------------------------------------
gt; Blade2304's Profile: www.excelforum.com/member.php...oamp;userid=33492
gt; View this thread: www.excelforum.com/showthread...hreadid=542610
gt;
gt;


Thanks, thats worked exactly how i wanted it to--
Blade2304
------------------------------------------------------------------------
Blade2304's Profile: www.excelforum.com/member.php...oamp;userid=33492
View this thread: www.excelforum.com/showthread...hreadid=542610You are welcome.
--
Kevin Vaughnquot;Blade2304quot; wrote:

gt;
gt; Thanks, thats worked exactly how i wanted it to
gt;
gt;
gt; --
gt; Blade2304
gt; ------------------------------------------------------------------------
gt; Blade2304's Profile: www.excelforum.com/member.php...oamp;userid=33492
gt; View this thread: www.excelforum.com/showthread...hreadid=542610
gt;
gt;