rocket0612 wrote:
I currently use VLOOKUP to find the address for a company when their
name is input. It returns the address but I would also like it to
return the row it gets the details from, is this possible?

thanks



Given in A2:B4:

x,7
y,6
z,9

the formula:

=VLOOKUP("y",$A$2:$B$4,2,0)

would return 6.

=MATCH("y",$A$2:$A$4,0)

would return the position of the lookup value "y", therefore also of the
value associated with it.

=MATCH("y",$A$2:$A$4,0)+ROW($A$2)-1

would return the native row number at which "y" is.

=CELL("Address",INDEX($B$2:$B$4,MATCH("y",$A$2:$A$ 4,0)))

would return the cell reference of the value associated with "y".