View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MAS MAS is offline
external usenet poster
 
Posts: 2
Default check first 3 characters of a cell and compare to a table

Hi all,

I am looking for help with a formula that will look up the first 3
characters in a cell, compare it too a table in a different workbook and
return the result of "check" if the 3 characters match an entry in the
table