View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CraigS
 
Posts: n/a
Default Any way for 2 column vlookups. i.e match last name then match firs

The only complete matching information in both databases is last name and
first name. Database 2 is actually a smaller list pulling info from the
larger database 1. The second database needs to pull social security info
from databse 1 to put in database 2. Because of multiple last names
matching I first want to match the last name in database 1 but somehow then
have an "AND" statement that then requires a first name match at which point
it will pullout the SS # from the row where both last and first names match.