How to find first occurance of a number in Excel

[AZUL]

I have a worksheet which involves 1000's of records in it. In that worksheet I want to find the first occurrence of a data entry throughout the worksheet. But I don't know how to fetch this data entry. It is very tedious task to do that manually. Can you help me how to find first occurrence in Excel?

[ThoMas321]

You can use VLOOKUP to find the first occurrence of a particular value in a worksheet or a database. In the next cell, put the function like "=VLOOKUP(data_value,cols,number_of_col,FALSE)". This function will find the "data_value" entry in "cols" column.

[JonathanD]

You can even use a VB code to find the first occurrence of the entries as follows:

	Function FindNthOccurrence(Table As Range, Val1 As Variant,Val1Occurrence As Integer, Val2 As Variant,Val2Col As Integer, ResultCol As Integer)

	Dim i As Integer
	Dim iCount As Integer
	Dim rCol As Range

		For i = 1 To Table.Rows.Count

			If Table.Cells(i, 1) = Val1Occurrence And Table.Cells(i, Val2Col) = Val2 Then
				iCount = iCount + 1
			End If

			If iCount = Val1Occurrence Then
				FindNth = Table.Cells(i, ResultCol)
				Exit For
			End If

		Next i

End Function

[chroma]

Excel has an inbuilt function know as "MATCH" which finds the exact match of your value. This function returns the row number of the first occurrence of that value.

Syntax: "=MATCH(lookup_value,lookup_array,match_type)"

where
lookup_value is the data entry that you want to find
lookup_array is the range of column in which you want to find the data entry
match_type is the boolean value whether the match was found or not