Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How make text appear in a cell as a result of a number in another
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How make text appear in a cell as a result of a number in another
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, Dave "Jeff Ellison" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How make text appear in a cell as a result of a number in another
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 FormatCellsNumber TabCategory: Text B2: Fred Bloggs Ltd Continue filling in the list When done... Select from A2 through the last item in Col_B InsertNameDefine 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),"",VLOOKUP(A2,LU_MfgInfo,2,0)) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Jeff Ellison" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How make text appear in a cell as a result of a number in anot
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 "Ron Coderre" wrote: 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 FormatCellsNumber TabCategory: Text B2: Fred Bloggs Ltd Continue filling in the list When done... Select from A2 through the last item in Col_B InsertNameDefine 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),"",VLOOKUP(A2,LU_MfgInfo,2,0)) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Jeff Ellison" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How make text appear in a cell as a result of a number in anot
Wow! Thanks for your help. They don't have a section "Idiot's guide" do they?
"David Billigmeier" wrote: 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, Dave "Jeff Ellison" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How make text appear in a cell as a result of a number in anot
Maybe...
http://contextures.com/xlFunctions02.html From Debra Dalgleish's site. Jeff Ellison wrote: Wow! Thanks for your help. They don't have a section "Idiot's guide" do they? "David Billigmeier" wrote: 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, Dave "Jeff Ellison" wrote: 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 -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How make text appear in a cell as a result of a number in anot
If I use my own Headings, Supplier Number, Supplier Name, what would I have
to do with the formula? Use any headings you like...They aren't used in the solution I posted. *********** Best Regards, Ron XL2002, WinXP-Pro "Jeff Ellison" wrote: 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 "Ron Coderre" wrote: 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 FormatCellsNumber TabCategory: Text B2: Fred Bloggs Ltd Continue filling in the list When done... Select from A2 through the last item in Col_B InsertNameDefine 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),"",VLOOKUP(A2,LU_MfgInfo,2,0)) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Jeff Ellison" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you make cell 2 return data if cell 1 contains text? | Excel Discussion (Misc queries) | |||
convert number in cell to text in another cell | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
edit number in cell without it changing to text | Excel Discussion (Misc queries) | |||
How to make a cell return the formatted value in a text string (i. | Excel Worksheet Functions |