automatic address and phone cell entry
 

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.

automatic address and phone cell entry
 

Try VLOOKUP

HYH
--
AP

"flamingo1" a écrit dans le message de
...
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.