Hi

You need absolute references in your formula:

=VLOOKUP(Sheet2!C9,Sheet3!$A$4:$B$6,2)

Regards,
Per

On 31 Jan., 15:12, Rich wrote:
Heres what i basically need help with :phttp://i590.photobucket.com/albums/ss342/xXxRichMxXx/djfrekHELP.png

Thanks for helping guys this one has really stumped me -_-