Populate cell with another cells data.. Please Help!

I'm running an investment analysis sheet. I want to be able to input a value in one cell, and depending on that value, have the corresponding number to that value populated into a third cell.

example:

A1-A5:B1-B5

6:100
6.5:150
7:200
7.5:250

If I input 6 into C1, it will populate D1 with corresponding number for 6 (100).... and be able to do this with all 4 inputs

Thanks

Originally Posted by FDibbins

Hi and welcome to the forum

If I understand you correctly, you need to use vlookup for this...

D1 =vlookup(C1,$A$1:$B$5,2,false)

Awesome - think i got it to work just right.

Thanks so much for the help - excited to show my boss!