vlookup help

[RedFive]

What I am trying to do is look at a range(a1:e600), if there is a value in a
certain column(c), to display the entry in the corresponding column(b). I am
trying to use vlookup for this but I can't seem to get it to display the
corresponding column. Am I doing something wrong, or possibly using the
wrong function?

 

[John C]

=INDEX(B1:B600,MATCH(value,C1:C600,1))

Hope this helps.