Comparing 3 Columns

[thomsonsr]

I've been searching for a while, but I am out of my league trying to
figure this one out on my own. I would like to compare three columns.

A B C
1 .25 3
2 .50 3
3 .75 1
4 1.00 1
2
4

The first two are static, but the third will change daily. I would
like to create a 4th column that compares cloumn C to column A and
outputs the corresponding column B value in column D. So, in this
example column D would read:

D
..75
..75
..25
..25
..50
1.00

Thank you for the help!

 

[Glenn]

I've been searching for a while, but I am out of my league trying to
figure this one out on my own. I would like to compare three columns.

A B C
1 .25 3
2 .50 3
3 .75 1
4 1.00 1
2
4

The first two are static, but the third will change daily. I would
like to create a 4th column that compares cloumn C to column A and
outputs the corresponding column B value in column D. So, in this
example column D would read:

D
.75
.75
.25
.25
.50
1.00

Thank you for the help!

=VLOOKUP(C1,$A$1:$B$4,2,FALSE)

http://www.contextures.com/xlFunctions02.html

 

[thomsonsr]

=VLOOKUP(C1,$A$1:$B$4,2,FALSE)

http://www.contextures.com/xlFunctions02.html- Hide quoted text -

- Show quoted text -

Thank you! It worked perfectly.