View Single Post
  #1   Report Post  
Des
 
Posts: n/a
Default How do I lookup a corresponding value in another table

I am trying to create a lookup where I am entering a 6 account number digit
but my 2 col lookup database has 16 number digits in col 1. I want my
lookup to ignore the last 10 digits in this table and give me the
corresponding text from col2 in table.