How to get row index if Excel has duplicate row

Please try sharing the “Lookup range” snapshot / complete details on it…