Forum Discussion
Return a text from a column given it exist in another column
Hello,
I would like to return a text from column D given it exist in column A (like in column B).
The file i have has over 50k lines and the formulas witch search and find did not work due to complexity.
Attached a table like an example:
| Column A | Column B | Column C | Column D |
| Document number | What it should be returned | Return formula | Explanation |
| 1 | 1 | Invoice no 1 from 01.01.2021 | |
| 2 | 3 | Invoice no 3 from 03.04.2022 | |
| 3 | 4 | Invoice no 4 from 05.03.2021 | |
| 4 | 10 | Invoice no 10 from 05.03.2022 | |
| 5 | 2 | Invoice no 2 from 03.08.2021 | |
| 6 | 6 | Invoice no 6 from 05.02.2022 | |
| 7 | 8 | Invoice no 8 from 05.04.2020 | |
| 8 | 30 | Invoice no 30 from 05.03.2022 | |
| 9 | 9 | Invoice no 9 from 01.08.2022 | |
| 10 | 7 | Invoice no 7 from 03.03.2022 |
Best regards,
Mihai
