Jobie,

try this

=INDEX($A$1:$B$6,MATCH(TRUE,EXACT(C1,$A$1:$A$6),0),2)

Its an Array formula. Use Ctrl+shift+Enter