I just realized why it's not working. On the Salesman sheet, all down Column D are formulas of =A1&" "&B1 to combine the first and last name -- so it appears blank, but really isn't. Is it still possible to do what I'm looking for? Thanks