Did you get it? If not the copy this in D1 of Sheet 2
=VLOOKUP(C1,Sheet1!A:F,6,FALSE)
and copy down till the cell you want the values in

"Bombay" wrote:

I think I almost have it.

Though my Data is a little different than my example.

Sheet 1
Column A = Names
Column F = Numerical Values

Sheet 2
Column C = Names
Column D = Empty Value(Where I want values entered from Column F to be
populated)

There are a total of 32 names and values.