Have a look at Chip Pearson's methods of left lookup.

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


Gord Dibben Excel MVP

On Sat, 8 Oct 2005 14:11:55 -0500, Brisbane Rob
wrote:


I thought this would be easy but still can't get it. How do you get a
vlookup to return a value from a column to the left of the array?

Thanks