Hello
I am trying to do a vlookup from an assessment grid. Being a newbie, had a look on google and managed to get a formula and it pulled out the data. I thought great!!! problem solved. Carried the formula down and I could see data which I thought was great.... then realised it's not pulling through what I want. Any help would be appreciated...for an expert it would take minutes. I can't attach a file but will try to explain..
=VLOOKUP(AD3,'English Language_EAP (4)'!$A$2:$R$34,12,FALSE)
AD3= Cell reference
English Language_EAP (4) is the worksheet with the matrix
$A$2 is the fixed cell reference
$R$34 is the fixed cell reference
12 is the coloumn index
FALSE is an exact match.
The grid contains +, =, - (numbers 1-9)
Baseline
9+
9=
9-
8+
8=
8-
7+
7=
7-
6+
6=
6-
5+
5=
5-
4+
4=
4-
3+
3=
3-
2+
2=
2-
1+
1=
1-
Yr11
9=
9-
8+
8=
8-
7+
7=
7-
etc etc
Kind Regards
M Dabbs
I am trying to do a vlookup from an assessment grid. Being a newbie, had a look on google and managed to get a formula and it pulled out the data. I thought great!!! problem solved. Carried the formula down and I could see data which I thought was great.... then realised it's not pulling through what I want. Any help would be appreciated...for an expert it would take minutes. I can't attach a file but will try to explain..
=VLOOKUP(AD3,'English Language_EAP (4)'!$A$2:$R$34,12,FALSE)
AD3= Cell reference
English Language_EAP (4) is the worksheet with the matrix
$A$2 is the fixed cell reference
$R$34 is the fixed cell reference
12 is the coloumn index
FALSE is an exact match.
The grid contains +, =, - (numbers 1-9)
Baseline
9+
9=
9-
8+
8=
8-
7+
7=
7-
6+
6=
6-
5+
5=
5-
4+
4=
4-
3+
3=
3-
2+
2=
2-
1+
1=
1-
Yr11
9=
9-
8+
8=
8-
7+
7=
7-
etc etc
Kind Regards
M Dabbs
Last edited by a moderator: