From what you described, it sounds like the VLOOKUP function will work.

You give VLOOKUP a value, a range and a return column. The function will then look for the value in the range and then...

Here are the steps to making one cell display the information in another cell. When the source cell is changed, the cell that refers to it will change as well:

1) Click on the cell that will...