Forum Discussion
Copy on complex condition
Only for great experts! I would like to set the following formula, but I don't know if it can be done, can anyone help me? I have two columns M and N. In column M I have approximately twenty numbe...
In A2, if you have Microsoft 365, Office 2024 or Office 2021:
=XLOOKUP(A1, M1:M20, N1:N20, "")
If you have an older version:
=IFERROR(VLOOKUP(A1, M1:N20, 2, FALSE), "")
Thanks, Hans
the formula is wrong but I didn't know it so you put me on the right track. I found the Italian equivalent and solved it, thanks.
