How to get row index if Excel has duplicate row

johnson24x7 (Maryson) August 27, 2022, 7:01am 20

Maybe this is solved… But in Excel, any VLOOKUP HLOOKUP etc formulae will only pick the first occurrence. If there are duplicate values / multiple occurrences; it will not move to the 2nd one and give the lookup value.

Topic		Replies	Views
LookUp Range Activity - How to get the index of "second occurrence/Second Match" of a value? Help	7	3563	July 26, 2020
How to find the cell value in the excel Studio studio , question , activities_panel	8	1204	November 29, 2023
Get the row index on the basis on value of index from excel Help excel , activities , question	4	3061	January 31, 2020
Need the row index of a given value if there are multiple intense of it! Studio studio , question , new_feature_request	4	1175	July 12, 2022
How to perform lookup or index on filtered blank cells Activities excel , activities , question	1	882	June 4, 2021

How to get row index if Excel has duplicate row

Related topics