ExcelBanter - Cell address from Vlookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Cell address from Vlookup (https://www.excelbanter.com/excel-programming/334144-cell-address-vlookup.html)

Harry

Cell address from Vlookup

Is it possible when using Vlookup within VBA so that it returns the cell
address as the output rather than the cell value?

Tom Ogilvy

Cell address from Vlookup

Then you would use Match

=Address(match(Target,A1:A1000,0),1)

--
Regards,
Tom Ogilvy

"Harry" wrote in message
...
Is it possible when using Vlookup within VBA so that it returns the cell
address as the output rather than the cell value?

Philip

Cell address from Vlookup

Not with VLOOKUP

You have to use MATCH to return the row, MATCH to return the column, and
ADDRESS (with the results of the MATCH column and Row values) to return the
address

HTH

Philip

"Harry" wrote:

Is it possible when using Vlookup within VBA so that it returns the cell
address as the output rather than the cell value?

All times are GMT +1. The time now is 12:39 PM.