I have two columns "A" and "C" containing names of people. Columns "B" and "D" contain their birth dates. How can I make 1 data validation table for columns A & C without having to make them in one long column?
A B C D
John 3.12.14 Tony 9.4.14
Display will be: Tony (in one cell); 9.4.14 in the the next. (Say col. E and F)
Altogether there are 4 columns for the vlookup formula.