Vlookup Help Beginner

[d488z]

Hello - First of all thanks for taking the time to read this post..

I am trying to do a Vlookup for example look at Col Eng which has a 3- then look at Baseline find the 3- in the list and output what is in the next columns, the out put I am looking for is 1= (and the rest of that line)....3- 1=,1+,2-,2=,2+

I am trying this =VLOOKUP(A2,D2:I33,2,FALSE) which sort of works but when I try to stretch the formula to the next column I get 3= which is incorrect. Much appreciated.

Eng	Mat	Sci	Baseline	Year 7 Term 3	Year 8 Term 3	Year 9 Term 3	Year 10 Term 3	Year 11 Term 3
3-	2+	2=	9=	6-	6+	7=	8=	9=
4+	4+	4+	9-	5+	6=	7-	8-	9-
2+	2=	2	8+	5=	6-	6+	7+	8+
2+	1	1	8=	5-	5+	6=	7=	8=
1-			8-	5-	5=	6-	7-	8-
2=			7+	4+	5+	6-	7-	7+
			7=	4+	5=	6-	6+	7=
			7-	4=	5-	5+	6=	7-
			6+	4=	5-	5+	6-	6+
			6=	4-	4+	5=	5+	6=
			6-	4-	4+	5-	5=	6-
			5+	3+	4=	4+	5-	5+
			5=	3=	4-	4=	4+	5=
			5-	3=	4-	4=	4+	5-
			4+	3-	3+	4-	4=	4+
			4=	2+	3=	3+	4-	4=
			4-	2=	3-	3=	3+	4-
			3+	2-	2+	3-	3=	3+
			3=	1+	2=	2+	3-	3=
			3-	1=	1+	2-	2=	2+
			2+	1-	1=	1+	2-	2=
			2=	1-	1=	1+	2-	2=
			2-	W4	1-	1=	1+	2-
			1+	W3	W4	1-	1=	1+
			1=	W2	W3	W4	1-	1=
			1-	W1	W2	W3	W4	1-
			W4
			W3
			W2
			W1
			U
			X	X	X	X	X	X

<tbody>
</tbody>

 

[philwojo]

I think you just need to lock your cell references, try this:

[COLOR=#333333]=VLOOKUP($A$2,$D$2:$I$33,2,FALSE)[/COLOR]

Then update the "2" to be the next column you want, so in your 2nd formula it would be 3, then 4 etc.

 

[KennyGreens]

Hi, I'm not sure how you're going about stretching the formula, but it would work better using absolute/mixed references. For example (each formula assumes you are only using A2 as the lookup value, change the referencing accordingly):

=VLOOKUP($A$2,$D$2:$I$33,2,FALSE)
=VLOOKUP($A$2,$D$2:$I$33,3,FALSE)
=VLOOKUP($A$2,$D$2:$I$33,4,FALSE)

This should work as, and this is just an assumption, it seems that you dragged the formula 1 cell to the right, which changed the formula in that cell to =VLOOKUP(B2,E2:J33,2,FALSE), which if you see loooks for "2+" in the Year 7 Term 3 column and gives an answer of 3= in the next column.

 

[d488z]

Hi Thanks for your reply. This is what I did in the end =VLOOKUP(A2,EAP,2,FALSE). I named the range EAP but the same thing. I was hoping to you use the stretch or double click as I will have about 200 entries that I need to do multiply by 5 and then I have 13 subjects. What I am trying to do is map Targets for students through school.

I think you just need to lock your cell references, try this:

[COLOR=#333333]=VLOOKUP($A$2,$D$2:$I$33,2,FALSE)[/COLOR]

Then update the "2" to be the next column you want, so in your 2nd formula it would be 3, then 4 etc.

 

[philwojo]

Just update the formulas in your first row, then you can just copy down each column to all rows.