If I type a name from an existing list on another worksheet in Col A, I would
like the address, phone number or whatever to automatically pop into the next
consecutive columns without having to physically type the info in. what
formula would I use.