Hi, try giving these links a look. I prefer the Index/Match functions
over VLookup because you are not constrained by the order the table is
arranged or sorting.

http://www.contextures.com/xlFunctions03.html

http://www.contextures.com/xlFunctions02.html

http://www.cpearson.com/excel/lookups.htm

HTH--Lonnie M.