Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi

With D1 containing the search value, and A1:A10 containing the data, you can use:

=CELL("address";INDIRECT("A"&MATCH(D1;A1:A10;0)))

See Adresse.ods example.