Hi,

Am Sun, 14 Aug 2011 09:48:27 +1000 schrieb Mas:

i.e. Column A - AA1-0001, AB2-0002, etc

I would like to perform a lookup on the first three character ie.e AA1
or AB2 etc.

try:
=INDEX(A:A,MATCH("AA1*",A:A,0))
or
=VLOOKUP("AA1*",A:A,1,0)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2