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.