locate the position of a given value in a given column in Excel

[Simone328]

Hello,

my vlookup did return a value however I thin it is lying to me. When I have a filer on the column and look for the value as a check, it does not appear.
When I try a control f the value does not appear.

I have not tried an index match yet.

Is there a simple formula to locate the position of a value in a column ?

thank you,
Rich

 

[AlanY]

this is a simple example how the match() work

Book1
	A	B	C	D
1	A		lookup	row
2	B		D	4
3	C
4	D
5	E
6	F
7	G
Sheet1

Cell Formulas
Range	Formula
D2	=MATCH(C2,A:A,0)

 

[Simone328]

Thank you very much!

 

[AlanY]

you're welcome