Thread: activecell & Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
flow23
 
Posts: n/a
Default activecell & Vlookup
Is there a way to rewrite a vlookup based on activecell?

=VLOOKUP("activecell",Sheet1!A:B,2,FALSE)
where in it picks up value from the active cell?


Reply With QuoteReply With Quote