software

I am creating a database. Every time I enter a certain number (e.g. my
manufacturer's code) I'd like to be able to make the (manufacturer's) name
appear in a nominated cell. E.g every time I enter 0123 in one cell, Fred
Bloggs Ltd appears in an adjacent cell.
Can excel do this. I haven't a clue about Macros! Thanks1

Have a look at VLOOKUP() in the help menu, this will achieve what you want.
Post an example if you would like more in depth help.--
Regards,
Davequot;Jeff Ellisonquot; wrote:

gt; I am creating a database. Every time I enter a certain number (e.g. my
gt; manufacturer's code) I'd like to be able to make the (manufacturer's) name
gt; appear in a nominated cell. E.g every time I enter 0123 in one cell, Fred
gt; Bloggs Ltd appears in an adjacent cell.
gt; Can excel do this. I haven't a clue about Macros! Thanks1

Try this:

Put a new worksheet in your workbook, then:
A1: MfgID
B1: MfgName
A2: 0123 (or whatever products you have)
Note: If you want leading zeros...Format these cells as Text
Formatgt;Cellsgt;Number Tabgt;Category: Text

B2: Fred Bloggs Ltd
Continue filling in the list

When done...
Select from A2 through the last item in Col_B
Insertgt;Namegt;Define
Name in workbook: LU_MfgInfo
Refers to: (your already selected list)
Click the [OK] button

Then, on your input sheet...for a MfgID are in A2...
B2: =IF(ISBLANK(A2),quot;quot;,VLOOKUP(A2,LU_MfgInfo,2,0))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Jeff Ellisonquot; wrote:

gt; I am creating a database. Every time I enter a certain number (e.g. my
gt; manufacturer's code) I'd like to be able to make the (manufacturer's) name
gt; appear in a nominated cell. E.g every time I enter 0123 in one cell, Fred
gt; Bloggs Ltd appears in an adjacent cell.
gt; Can excel do this. I haven't a clue about Macros! Thanks1

Many Thanks.

You are a genius!I have not dared to put in anything other than your
headings, so have used exactly as you wrote. (Like painting with numbers!).
If I use my own Headings, Supplier Number, Supplier Name, what would I have
to do with the formula?

I know this must seem so thick, but better honest than ignorant!

Thanks Again

quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; Put a new worksheet in your workbook, then:
gt; A1: MfgID
gt; B1: MfgName
gt; A2: 0123 (or whatever products you have)
gt; Note: If you want leading zeros...Format these cells as Text
gt; Formatgt;Cellsgt;Number Tabgt;Category: Text
gt;
gt; B2: Fred Bloggs Ltd
gt; Continue filling in the list
gt;
gt; When done...
gt; Select from A2 through the last item in Col_B
gt; Insertgt;Namegt;Define
gt; Name in workbook: LU_MfgInfo
gt; Refers to: (your already selected list)
gt; Click the [OK] button
gt;
gt; Then, on your input sheet...for a MfgID are in A2...
gt; B2: =IF(ISBLANK(A2),quot;quot;,VLOOKUP(A2,LU_MfgInfo,2,0))
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Jeff Ellisonquot; wrote:
gt;
gt; gt; I am creating a database. Every time I enter a certain number (e.g. my
gt; gt; manufacturer's code) I'd like to be able to make the (manufacturer's) name
gt; gt; appear in a nominated cell. E.g every time I enter 0123 in one cell, Fred
gt; gt; Bloggs Ltd appears in an adjacent cell.
gt; gt; Can excel do this. I haven't a clue about Macros! Thanks1

Wow! Thanks for your help. They don't have a section quot;Idiot's guidequot; do they?

quot;David Billigmeierquot; wrote:

gt; Have a look at VLOOKUP() in the help menu, this will achieve what you want.
gt; Post an example if you would like more in depth help.
gt;
gt;
gt; --
gt; Regards,
gt; Dave
gt;
gt;
gt; quot;Jeff Ellisonquot; wrote:
gt;
gt; gt; I am creating a database. Every time I enter a certain number (e.g. my
gt; gt; manufacturer's code) I'd like to be able to make the (manufacturer's) name
gt; gt; appear in a nominated cell. E.g every time I enter 0123 in one cell, Fred
gt; gt; Bloggs Ltd appears in an adjacent cell.
gt; gt; Can excel do this. I haven't a clue about Macros! Thanks1

Maybe...

contextures.com/xlFunctions02.html
From Debra Dalgleish's site.

Jeff Ellison wrote:
gt;
gt; Wow! Thanks for your help. They don't have a section quot;Idiot's guidequot; do they?
gt;
gt; quot;David Billigmeierquot; wrote:
gt;
gt; gt; Have a look at VLOOKUP() in the help menu, this will achieve what you want.
gt; gt; Post an example if you would like more in depth help.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Regards,
gt; gt; Dave
gt; gt;
gt; gt;
gt; gt; quot;Jeff Ellisonquot; wrote:
gt; gt;
gt; gt; gt; I am creating a database. Every time I enter a certain number (e.g. my
gt; gt; gt; manufacturer's code) I'd like to be able to make the (manufacturer's) name
gt; gt; gt; appear in a nominated cell. E.g every time I enter 0123 in one cell, Fred
gt; gt; gt; Bloggs Ltd appears in an adjacent cell.
gt; gt; gt; Can excel do this. I haven't a clue about Macros! Thanks1

--

Dave Peterson

gt; If I use my own Headings, Supplier Number, Supplier Name, what would I have
gt; to do with the formula?

Use any headings you like...They aren't used in the solution I posted.

***********
Best Regards,
Ron

XL2002, WinXP-Proquot;Jeff Ellisonquot; wrote:

gt; Many Thanks.
gt;
gt; You are a genius!I have not dared to put in anything other than your
gt; headings, so have used exactly as you wrote. (Like painting with numbers!).
gt; If I use my own Headings, Supplier Number, Supplier Name, what would I have
gt; to do with the formula?
gt;
gt; I know this must seem so thick, but better honest than ignorant!
gt;
gt; Thanks Again
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; Try this:
gt; gt;
gt; gt; Put a new worksheet in your workbook, then:
gt; gt; A1: MfgID
gt; gt; B1: MfgName
gt; gt; A2: 0123 (or whatever products you have)
gt; gt; Note: If you want leading zeros...Format these cells as Text
gt; gt; Formatgt;Cellsgt;Number Tabgt;Category: Text
gt; gt;
gt; gt; B2: Fred Bloggs Ltd
gt; gt; Continue filling in the list
gt; gt;
gt; gt; When done...
gt; gt; Select from A2 through the last item in Col_B
gt; gt; Insertgt;Namegt;Define
gt; gt; Name in workbook: LU_MfgInfo
gt; gt; Refers to: (your already selected list)
gt; gt; Click the [OK] button
gt; gt;
gt; gt; Then, on your input sheet...for a MfgID are in A2...
gt; gt; B2: =IF(ISBLANK(A2),quot;quot;,VLOOKUP(A2,LU_MfgInfo,2,0))
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;Jeff Ellisonquot; wrote:
gt; gt;
gt; gt; gt; I am creating a database. Every time I enter a certain number (e.g. my
gt; gt; gt; manufacturer's code) I'd like to be able to make the (manufacturer's) name
gt; gt; gt; appear in a nominated cell. E.g every time I enter 0123 in one cell, Fred
gt; gt; gt; Bloggs Ltd appears in an adjacent cell.
gt; gt; gt; Can excel do this. I haven't a clue about Macros! Thanks1