Thread: How do I get the cell address of a VLOOKUP reference?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tfleischny
 
Posts: n/a
Default How do I get the cell address of a VLOOKUP reference?
I'm trying to get the cell address, not the contents, of a cell referenced
using VLOOKUP. I've tried '=CELL("address", VLOOKUP(5,Table,2,false)', but
I'm getting a formula error. EXCEL 2003. Thanks.
Reply With QuoteReply With Quote