| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If then statement question....
I use Excel 2000 9.0 as a pruchasing program.
I would like for Excel to recognize which vendor I enter into column c, and then automatically enter who my sales rep is into column J. I also would use this same method to recognize item descriptions in column D and automatically input the respective part numbers. Thanks in advance, |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
If then statement question....
The feature you are looking for is called VLOOKUP........
Your formula will look something like this......... =VLOOKUP(C1,LISTOFREPS,2,FALSE) Check the Help section, and post back if you run into problems. Vaya cno Dios, Chuck, CABGx3 "atlcasework" wrote: I use Excel 2000 9.0 as a pruchasing program. I would like for Excel to recognize which vendor I enter into column c, and then automatically enter who my sales rep is into column J. I also would use this same method to recognize item descriptions in column D and automatically input the respective part numbers. Thanks in advance, |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
If then statement question....
Have a look in Excel help for the VLOOKUP function.
-- David Biddulph "atlcasework" wrote in message ... I use Excel 2000 9.0 as a pruchasing program. I would like for Excel to recognize which vendor I enter into column c, and then automatically enter who my sales rep is into column J. I also would use this same method to recognize item descriptions in column D and automatically input the respective part numbers. Thanks in advance, |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
If then statement question....
I'm sorry, but the first response was not very helpful.
I need an example or two to extrapolate from. I'm not sure how to implement "vlookup". Thanks in advance, "atlcasework" wrote: I use Excel 2000 9.0 as a pruchasing program. I would like for Excel to recognize which vendor I enter into column c, and then automatically enter who my sales rep is into column J. I also would use this same method to recognize item descriptions in column D and automatically input the respective part numbers. Thanks in advance, |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
If then statement question....
Thank you David,
I have already looked at that particular help file, but I still do not understand. Could you possibly redirect me to a forum where I can obtain some examples, it seems as though I am not in the correct forum for such assistance. Thank you "David Biddulph" wrote: Have a look in Excel help for the VLOOKUP function. -- David Biddulph "atlcasework" wrote in message ... I use Excel 2000 9.0 as a pruchasing program. I would like for Excel to recognize which vendor I enter into column c, and then automatically enter who my sales rep is into column J. I also would use this same method to recognize item descriptions in column D and automatically input the respective part numbers. Thanks in advance, |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
If then statement question....
Debra Dalgleish has lots of notes on =vlookup():
http://www.contextures.com/xlFunctions02.html atlcasework wrote: I use Excel 2000 9.0 as a pruchasing program. I would like for Excel to recognize which vendor I enter into column c, and then automatically enter who my sales rep is into column J. I also would use this same method to recognize item descriptions in column D and automatically input the respective part numbers. Thanks in advance, -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
If then statement question....
VLOOKUP formulas will pull the data to appropriate cells.
See Debra Dalgleish's site for more on VLOOKUP and Data Validation lists for entering the choices. http://www.contextures.on.ca/xlFunctions02.html http://www.contextures.on.ca/xlDataVal01.html Note the section on using DV lists from another worksheet by naming the list. Also note the sample file(s) you can download. Gord Dibben MS Excel MVP On Mon, 14 Jan 2008 08:35:02 -0800, atlcasework wrote: I'm sorry, but the first response was not very helpful. I need an example or two to extrapolate from. I'm not sure how to implement "vlookup". Thanks in advance, "atlcasework" wrote: I use Excel 2000 9.0 as a pruchasing program. I would like for Excel to recognize which vendor I enter into column c, and then automatically enter who my sales rep is into column J. I also would use this same method to recognize item descriptions in column D and automatically input the respective part numbers. Thanks in advance, |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
If then statement question....
Thank you very much for the replies.
I don't need any further assistance. "Dave Peterson" wrote: Debra Dalgleish has lots of notes on =vlookup(): http://www.contextures.com/xlFunctions02.html atlcasework wrote: I use Excel 2000 9.0 as a pruchasing program. I would like for Excel to recognize which vendor I enter into column c, and then automatically enter who my sales rep is into column J. I also would use this same method to recognize item descriptions in column D and automatically input the respective part numbers. Thanks in advance, -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement question | Excel Worksheet Functions | |||
| IF statement question | Excel Worksheet Functions | |||
| IF Statement Question | Excel Worksheet Functions | |||
| If Statement Question | Excel Worksheet Functions | |||
| IF Statement question | Excel Worksheet Functions | |||
Linear Mode
