You can use =vlookup() to do what you want.

Just a suggestion: I'd move the table to a different worksheet to keep it
safe(r).

Debra Dalgleish has some notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())

CrimsonPlague29 wrote:

Hello,
I have data as follows
Item A Item B Item C Item D
1 10
2 20

What I require is that when user enters info in Item C column that the
corresponding Item B appears in Item D column.
example: user enters 1 in Item C column want 10 to appear in Item D column

Please Advise
Thanks

--

Dave Peterson