Thread: How to obtain cell address of a succesful VLookup?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] EagleOne@discussions.microsoft.com is offline
external usenet poster
  
Posts: 391
Default How to obtain cell address of a succesful VLookup?
2003/2007

If the following is successful:

=VLOOKUP(J68,'1000'!$J$139:$J$150,1,FALSE)

How can I easily ID the found cell reference to use in subsequent VBA?

TIA EagleOne
Reply With QuoteReply With Quote