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

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

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

I think this will do you if i'm looking at this right:
=vlookup(E20,B2:C2000,2,false)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"WiFiMike2006" wrote:

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