hi Keith,

The FAQ section mentions how to mark threads as Solved (http://www.excelforum.com/faq.php).

Shg's got you sorted for your current issue but if you are interested in learning an alternative to Vlookup, have a read of the below link on Charles' site, esp the section titled "VLOOKUP versus INDEX and MATCH or OFFSET".
http://www.decisionmodels.com/optspeede.htm
(in fact, I recommend reading the whole site!)

These pages may explain the Index/Match concept more clearly: http://www.mrexcel.com/articles/exce...ndex-match.php or http://www.ozgrid.com/Excel/left-lookup.htm

Rob