Need Formula help with pulling value from a list

[jeremyh22]

Hey,

So I am trying to figure out a way to get a value to auto populate based on the value in another cell. Here is what I looking for. I have made lists which have the names(column A) and values (column B), but  but would like the column D to pull the value from Column B based on Column C which will be picked from a list of Column A. Any idea how to do that and make it to where if Column A changes it's not a complete mess to change?

Known Info

Column A (Name)	Column B (Value)
Company ABC	123
Company BCD	234
Company CDE	345

Column C (User Input)	Column D (Value Needed Based on Column C)
Company CDE	?

[#2]

@jeremyh22 

=VLOOKUP(C2,$A$2:$B$4,2,FALSE)

=INDEX($B$2:$B$4,MATCH(C2,$A$2:$A$4,0))

You can apply these formulas.

[#3]

Could I do that for an entire column where each cell could be different? Basically Column C and Column D would continue for 80-100 cells.

[#4]

@jeremyh22 

=IFERROR(VLOOKUP(C2,$A$2:$B$6,2,FALSE),"")

You can fill the formula down as required. And you can add data in columns A and B as well. If there is a user input in column C that is missing in column A you can add IFERROR in order to return e.g. an empty cell instead of an error. In the example the input from cell C10 isn't found in column A and the IFERROR returns an empty cell in D10.