Copying the value in a cell based on other cells matching

I'm sure this is a simple problem to solve but I am struggling so thought I would seek help.

Basically I have the following setup:

Team Names in Column A Points scored in Column B

I want to then enter the Team Names in Column C and to then have a formula in Column D which checks the name I've added to Column C against the names in Column A and automatically shows the points scored from Column B.

So as an example - Column A = "Man Utd" Column B = "3" I then type "Man Utd" into Column C and would want "3" (from Column B) to automatically appear in Column D

I guess this is possible but I have tried various VLOOKUP, MATCH, IF (to name a few) formulae with no joy. If anyone can assist it would be appreciated.

Thanks



Read more here: https://stackoverflow.com/questions/64946610/copying-the-value-in-a-cell-based-on-other-cells-matching

Content Attribution

This content was originally published by The_Train at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: