G
Guest
Is there a way to get vlookup to return the address
instead of the value of a cell. I can do this w/o VBA
using the function
=CELL("address",INDEX(C7174,MATCH("b",C71:C74),2))
but the CELL function is not in the WorksheetFunction
object. Thanks in advance for any help with this.
instead of the value of a cell. I can do this w/o VBA
using the function
=CELL("address",INDEX(C7174,MATCH("b",C71:C74),2))
but the CELL function is not in the WorksheetFunction
object. Thanks in advance for any help with this.