On Jul 22, 1:06 pm, ChrisP wrote:
I have 2 different columns on a spreadsheet, one is "who" and the other is
"contractor". I would like to have a drop down on a separate spreadsheet that
would pull back both the who and contractor names. I know I have to define a
name but I can't figure out how to define 2 separate columns into one name.
BTW, the columns must stay separate for various reasons so I can't just make
one large list... Any help is appreciated!!!

Make a 3rd column somewhere, hidden perhaps, with the 2 names
concatenated.
=CONCATENATE(A1,B1)
=A1&B1

Then reference this column for your drop down.