Vlookup (Excel 2003)

Topic

New Reply

hi there
having trouble with the vlookup.
in cell I17 i want to use the Vlookup table i have produced to find whether the grades in cells (G17:G56) are fail, pass, merit and to return the data fail, pass or merit in cell I17. i have made tried and failed can you please show me where im going wrong and explain why my function that is already in cell I17 doesnt work.
thank you as always kitty

=VLOOKUP(“Result”,Grade_Lookup_Table,15,G17:G56)

Reply | Quote

Replies

(Edited by sdckapr on 16-Jan-08 07:43. Added Question on scores <40)

How about:
=VLOOKUP(G17,Grade_Lookup_Table,2)

Steve
PS what does the score of “34” get. It is <40 and nothing is listed for <40….

Reply | Quote

hi there i still cant get it to work like you said for under 40 is a fail
where am i going wrong?

Reply | Quote

hi there is there any way round this as ive been trying all kinds
<40 under 40= Fail
75 over 75= Merit

thanks kitty

i have reattached the new sheet, as it only produces merits and i dont no what more i can do to change it.

Reply | Quote

If 0 – 40 is a fail
40-60 is a Pass
>75 is merit

What about 60-75??

The cells in M must be numbers to use Vlookup.

Your lookup table should be like:

	M	N
16	0	Fail
17	40	Pass
18	60	???
19	75	Merit

This means:
from >=0 by =40 and =60 and =75 will be Merit

You have numeric divisions you need 4 descriptions.

You would use in I17:
=VLOOKUP(G17,Grade_Lookup_Table,2)

Steve

Reply | Quote

Hi,
A quick fix would be: Change your lookup table to 1 – fail, 40 – pass, 76 – merit
This would mean, 1 to 39 = fail, 40 to 75 = pass and 76 and over = merit
Also, grade or points reference should be cell reference (G18 etc.)
Max

Reply | Quote

hi there it still doesnt work can you please try for your self on my attached file using the vlookup table called “vlookup”

thanks kitty

Reply | Quote

In I17:
=VLOOKUP(G17,vlookup,2)

You have:
=VLOOKUP(“Result”,vlookup,2)

And the text “Result” is not found in the list, and it is <0 so it gives the value in cell N15 which is blank. The result is the value of zero(0)

Steve

Reply | Quote

ohhhhhhhhhhhhhhhhhhh thank you so much

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Reply | Quote