How do I enter data in an adjacent cell based on a list selection?

[Guest]

I have 2 sheets in this workbook. Sheet 1 (named "part list") has a range
B2:B2000 which I have named "parts". In column C I have another range
(C2:C2000) named "description." My question is, after I have the data
validation list set up in the cells of column E on sheet 2 (named "R&D log"),
how can I make the cell in the same row in column F come up as the
description that goes with the selected part?

For example:

sheet 1

B C
PN description
1 1 part 1
2 2 part 2
3 3 part 3
4 4 part 4

sheet 2

E F
20 4 part 4
21 1 part 1
22 3 part 3

I think it has something to do with VLOOKUP, but I can't seem to get it to
work right. Please help if you can.

THANK YOU!

Mike

 

[Guest]

I think this will do you if i'm looking at this right:
=vlookup(E20,B2:C2000,2,false)