Thread: How to lookup based in the first 3 characters of a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mas[_4_] Mas[_4_] is offline
external usenet poster
  
Posts: 4
Default 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 QuoteReply With Quote