ok I'm 1/2 way there. Now got
=IF(A8=A8,VLOOKUP(A8,A2:E6,5,FALSE),IF(A9=A9,VLOOK UP(A9,A2:E6,5,FALSE),IF(A10=A10,VLOOKUP(A10,A2:E6, 5,FALSE),"")))

Only problem is this formula does not match each of the IF statements.
In other words, if I type in Abby it will return 'G' and ignore
anything else I type into cells A9 or A10!!!
aaaaaaaaagggggggggghhhhhhhhhh!