If then statement question....

[atlcasework]

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,

 

[CLR]

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

 

[David Biddulph]

Have a look in Excel help for the VLOOKUP function.

 

[atlcasework]

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]

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

 

[Dave Peterson]

Debra Dalgleish has lots of notes on =vlookup():
http://www.contextures.com/xlFunctions02.html

 

[Gord Dibben]

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

 

[atlcasework]

Thank you very much for the replies.
I don't need any further assistance.