Comparing 3 Columns

  • Thread starter Thread starter thomsonsr
  • Start date Start date
T

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!
 
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!
Click to expand...


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

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