How to lookup based in the first 3 characters of a cell
 

Hi all,

I would like to know how I can perform a lookup formula to lookup a
column based on the first three characters of a cell.

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.

Thanks in advanced.

How to lookup based in the first 3 characters of a cell
 

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

How to lookup based in the first 3 characters of a cell
 

I'd use something like:

=vlookup(left(a1,3), .....



On 08/13/2011 18:48, Mas wrote:
Hi all,

I would like to know how I can perform a lookup formula to lookup a column based
on the first three characters of a cell.

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.

Thanks in advanced.

--
Dave Peterson