Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and replace specific characters within a cell based on positi | Excel Discussion (Misc queries) | |||
return value based on number of characters in cell / field | Excel Worksheet Functions | |||
Need to add figures based on alpha characters in the same cell | Excel Worksheet Functions | |||
Merge a cell based on count of characters | Excel Discussion (Misc queries) | |||
Lookup tab based on cell reference | Excel Discussion (Misc queries) |