If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Comparing 3 Columns
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! |
#3
|
|||
|
|||
Comparing 3 Columns
On Apr 22, 11:40*am, Glenn wrote:
=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. |
Thread Tools | |
Display Modes | |
|
|