SangeetaDNath
New member
- Joined
- Sep 6, 2017
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hello, Everyone,
I am a new member of this group. Finding difficulty in preparing an excel file.
I have values two columns and in third column I need to match each value in Col A with the values of Column B; if the value in column A is available in B then= the value in A or if it does not match then next available value out of the values in B.
A copy of excel sheet is attached. The expected results are also given for easy reference to use the formula.
Please help in this regrd.
I am a new member of this group. Finding difficulty in preparing an excel file.
I have values two columns and in third column I need to match each value in Col A with the values of Column B; if the value in column A is available in B then= the value in A or if it does not match then next available value out of the values in B.
A copy of excel sheet is attached. The expected results are also given for easy reference to use the formula.
Please help in this regrd.
Calculated Value | Given Value | Matched Value (expected result) |
1 | 1 | 1 |
2 | 6 | 3 |
5 | 3 | 5 |
9 | 5 | 10 |
7 | 10 | 10 |