Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009

    Unanswered: returning a cell's address from the results of a VLOOKUP


    I have successfully located an items (using VLOOKUP) on another worksheet. I now need to pull the value that is 1 row down and 11 columns to the right. I know how to use the OFFSET function, but I first need the address of the original item located in the VLOOKUP function.

    Does anyone know how to do this?



  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 17
    Look in the help file for the MATCH and INDEX functions. I'm sure that one of them returns the required cell address instead of contents.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts