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,

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,

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,

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,

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,

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

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,

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