I created a drop down list of Cust ID's. I have several cells containing
customer name, address, phone etc. that I want to prefill from the
spreadsheet that my CustID's came from, but I don't know how!
I created a drop down list of Cust ID's. I have several cells containing
customer name, address, phone etc. that I want to prefill from the
spreadsheet that my CustID's came from, but I don't know how!
Take a look at VLOOKUP in XL Help.
In article <[email protected]>,
"carris76" <[email protected]> wrote:
> I created a drop down list of Cust ID's. I have several cells containing
> customer name, address, phone etc. that I want to prefill from the
> spreadsheet that my CustID's came from, but I don't know how!
Sounds like VLOOKUP could do the trick.
For more on that Function see Debra Dalgleish's site.
http://www.contextures.on.ca/xlFunctions02.html
Also see Debra's site for info on Data Validation lists with drop-down box for
entering the code numbers.
http://www.contextures.on.ca/xlDataVal01.html
Might be useful.
Gord Dibben Excel MVP
On Sat, 28 May 2005 10:10:01 -0700, "carris76"
<[email protected]> wrote:
>I created a drop down list of Cust ID's. I have several cells containing
>customer name, address, phone etc. that I want to prefill from the
>spreadsheet that my CustID's came from, but I don't know how!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks