Insert a value based on row reference in another cell...

Hello,

I need to enter a value into a cell based on a value in another cell that is acting as a row reference. See attached:

cellValue.xlsx

You can see that the value in ColB is entered into ColA based on the row reference given in the cell values in ColC. I know this should be easy, but I stink at functions. Thanks guys.

You could use this:

Please Login or Register  to view this content.

but you will run into problems if the values are not unique.

Thanks ConneXionLost,

I incorporated match in the solution.