I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column.
Column: A B C D
1 1 Z Forumula: return value
1 2 Y
1 3 X
1 4 W
2 5 V
2 6 U
2 7 T
3 8 S
3 9 R
What I would like to happen in column D is for it to look at what is in column A, find the matching value in column B, and return the value listed in C. i.e. for any value of '1' in column A, I would want column D to display 'Z', for any value of '2' in column A, I would want column D to display 'Y', for any value of '3' in column A, I would want column D to display 'X', etc.
I've been driving myself crazy on excel trying to figure out a formula to calculate the responses for a test. Here's what I need it to do:
If the value in cell A2 matches the value in cell B2, I need it to display a 1.
If the value in cell A2 does NOT match the value in cell B2 and is not blank, I need it to subtract .25 or display -.25 (whichever).
If there is no value in cell A2 (if it's blank), I need it to display 0.
I can't find this anywhere because nothing explains how to pick between 3 inputs and then return one of 3 values.
I want a formula that will populate column D with the results of the following. It will find anything in column A that also appears in column B. If it appears in column B it will display the associated value from column C.
Assume that in A1:C5 I have the following table:
A B C
1 1 Low
2 1 Low Mod
3 1 Moderate
4 1 Mod High
5 1 High
And I have in Row 10 the following:
Row 10: A10=3 and B10=1
What sort of formula do I need to create in C10 that would look up the value from the table above (A1:C5) and would match the value of A10 to the relevant value in column A, and does the same for the value in B10 to the relevant value in column B so that the outcome is the corresponding value in column C... C3 = "Moderate"
Lookup_value is the value to be found in the first column of the array. Lookup_value can be a value, a reference, or a text string.
Table_array is the table of information in which data is looked up. Use a reference to a range or a range name, such as Database or List.
If range_lookup is TRUE, the values in the first column of table_array must be placed in ascending order: ..., -2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise VLOOKUP may not give the correct value. If range_lookup is FALSE, table_array does not need to be sorted.
You can put the values in ascending order by choosing the Sort command from the Data menu and selecting Ascending.
The values in the first column of table_array can be text, numbers, or logical values.