Hello,
I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column.
EX:
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.
Could someone help?
Thanks!
Thanks!
Keep up the good work