I have two tables:
- columns A (names) and B (empty)
- columns C (names) and D (values)
Columns A and B are sorted in a sheet in a way, C and D are sorted differently in another sheet. I want to get the values of column D in B respecting the way is sorted in the first sheet. In order to make it simple here, we’ll say they all are in the same sheet but with a different sorting method.
Here’s an little example where I removed most of the cells:
| Column A | Column B | Column C | Column D | |------------|----------|-----------|----------| | SI06SE020 | | SI06JA038 | 98,66 | | SI06JA023 | | MI06JA109 | 96,8 | | SI06JA038 | | SI06JA033 | 94,98 | | SI06JA039 | | SI06JA107 | 94,91 | | SI06JA040 | | SI06JA124 | 94,81 | | SI06JA124 | | SI06JA039 | 91,18 | | SI06SE139 | | SI06SE140 | 91,28 | | MI06HU065 | | SI06SE020 | 86,82 |
As you can see, A2 (SI06SE020) is the same value as the latest of column C.
I’m trying to get D values comparing A with C with Find(), so B2 formula would be
=FIND(A2;$C$2:$C$57;$D$2:$D$57). Instead of getting
86,82, I’m getting
94,81 (which belongs to SI06JA039) but have no idea of why.