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

Posted to microsoft.public.excel.misc

Mas[_4_]

external usenet poster

Posts: 4

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and replace specific characters within a cell based on positi	ccgsuper	Excel Discussion (Misc queries)	2	January 20th 09 02:34 PM
return value based on number of characters in cell / field	Perplexed	Excel Worksheet Functions	4	December 10th 08 08:48 PM
Need to add figures based on alpha characters in the same cell	Frustrated in Iowa	Excel Worksheet Functions	10	November 13th 08 09:16 PM
Merge a cell based on count of characters	Red2003XLT	Excel Discussion (Misc queries)	4	May 2nd 08 06:04 AM
Lookup tab based on cell reference	Sean Timmons	Excel Discussion (Misc queries)	3	January 6th 07 02:02 AM

All times are GMT +1. The time now is 04:21 AM.

Menu

About Us