I have a range with data and I need to know what the Row Number of a match in another range. Tricky bit is that the two sets only matches partially.
I have attached a slimmed-down version
Any help is much appreciated!!
I have a range with data and I need to know what the Row Number of a match in another range. Tricky bit is that the two sets only matches partially.
I have attached a slimmed-down version
Any help is much appreciated!!
Try in D5
=SUMPRODUCT(COUNTIF(C5,"*"&$A$1:$A$22&"*")*ROW($A$1:$A$22))
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
Ace_XL you are officially an Excel hero! i wished i had asked you 2 days ago.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks