FIND EXACT MATCH AND RETURN ROW NUMBER WHERE FOUND

Question

Hello everybody

here is a thing kinda hard to solve please

file attached with expected results

what is needed that to find exact match of four numbers at left in the table on right side and return number of the row where it was found

size of table or numbers might differ

thank you in advance

Answer 1

It already returns the 1st matching row number.

Regards,

Amit Tandon

www.excelanytime.com

Answer 2

Well, my friend...

Amit gave you a regular formula solution to your scenario, yet you said that these formulas are too slow.

If that is the case, no matter how I improve the code, the problem will remain the same, and that is because your data is quite large.

Suggestion:

Try using the formula given by Amit but saving your workbook as Excel Binary Workbook

And see how it goes.

Regards

Answer 3

Your formula uses COUNTIF to match the values. This may give erroneous results because it does not equate unique occurrences but only counts the number of occurrences in each row, for example, it may equate "4,13,14,26" to "4,4,14,26" or "13,13,14,26" whereas your intention is to compare occurrence of each of the 4 values of 4, 13, 14 and 26 in a row.

Regards,

Amit Tandon

www.excelanytime.com

Answer 4

Thank you both Amit and Jeovany 

Amit can you please make this formula of yours to find first matchnig row  , return number of row and then stop searching to save time ?

it can as well return yes or no when first matching row is found if it saves time too

thank you for helping

Answer 5

Hi Amit

can i regulate this formula if i need to find partial matches like 4 or 5 or 6 ?

thank you