Look at http://www.exceltip.com/st/Index_For...rmula/700.html and
and then http://office.microsoft.com/en-us/ex...001154902.aspx

In general VLookup only works if you are looking at the column on the leftmost of your range.