View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ChrisP ChrisP is offline
external usenet poster
 
Posts: 54
Default define name with 2 lists

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!!!