how to get the cell reference instead of its value?

[anenias]

I need some help to find a function than returns the line (or reference) in a table of certain value.
The function vlookup returns the value and i need the reference of that value.

[NBVC]

Use Match()

e.g. =Match(A1,B:B,0) will tell you the row number from column B that a match is found to lookup value in A1

[anenias]

Match was the right option!
More than a good answer... it was poetry in motion! lol

You could try to be a poet!
Thanks

[NBVC]

You are welcome!

Be aware that Match() gives the relative position within the defined range. Not necessarily the actual row number... If you use whole columns like B:B or if your range starts at row 1, then the position coincides with the row number, but if you have a defined range like B2:B15, then Match() will find the position number within that range that a match is found.