If I understand correctly this can be easily solved without VBA or UDF with a simple SUMPRODUCT function

See attached

Attached Files

FindRow.xlsx (9.6 KB, 13 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Yes. you are right. This problem can be solved with your approach without VBA. I didn’t understand the sumproduct can be used in such ways.
No. I didn’t understand the way you mention to thank to somebody to help me. Thank you very much for all the points.