Find exact match and return row number where found

[MIKE1122]

To get this as on attached file

[Richard Buttrey]

Hi,

Welcome to the forum
This looks like it may be a much simplified example and probably doesn't represent the size or detail of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

If so would you upload your real workbook (or at least a cut down copy), and manually add the results you expect to see.

[MIKE1122]

Dear Richard that is all true.
However in this case I need a solution for this current small example.
At least.

[oeldere]

This is a duplicate post of your question in the link below.

https://www.excelforum.com/excel-for...ow-number.html

[MIKE1122]

yes i had to modify a bit
cause i got partial solution

[AliGW]

Administrative Note:

This is becoming a habit of yours. You need to read our rules.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...ow-number.html