citrusfish
New Member
- Joined
- Nov 24, 2015
- Messages
- 11
Hi
This post has two requests
I have the data shown below:
<tbody>
</tbody>
I would like to research two possible options as I am not sure which will suit my purpose best:
1. Return in F2 the value of C2 or D2 which is closest to 0 and then copy the corresponding Target depending on whether Value Target 1 or Value Target 2 was the closest. So it would return -0.78 in F2 and 5 in E2.
2. Slightly easier I think. I want to return in F2 the Positive value from C2 or D2 and then copy the corresponding Target depending on whether Value Target 1 or Value Target 2 was the closest. So it would return 2.22 in F2 and 4 in E2.
I hope it is OK to ask two questions in one.
Many thanks for any help you can give.
Citrusfish
This post has two requests
I have the data shown below:
A | B | C | D | E | F | |
1 | Target 1 | Target 2 | Value of Target 1 | Value of Target 2 | Best Target | Best Value |
2 | 5 | 4 | -0.78 | 2.22 |
<tbody>
</tbody>
I would like to research two possible options as I am not sure which will suit my purpose best:
1. Return in F2 the value of C2 or D2 which is closest to 0 and then copy the corresponding Target depending on whether Value Target 1 or Value Target 2 was the closest. So it would return -0.78 in F2 and 5 in E2.
2. Slightly easier I think. I want to return in F2 the Positive value from C2 or D2 and then copy the corresponding Target depending on whether Value Target 1 or Value Target 2 was the closest. So it would return 2.22 in F2 and 4 in E2.
I hope it is OK to ask two questions in one.
Many thanks for any help you can give.
Citrusfish