Closed Thread
Results 1 to 7 of 7

Find Cell Address of a value found using a VLOOKUP Formula

  1. 10-16-2013, 08:19 AM #1
    ARGK
    ARGK is offline
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Find Cell Address of a value found using a VLOOKUP Formula

    Hi
    I am struggling to build a formula that gives me the address of a value found using a VLOOKUP Formula. I am trying to return the value above the row where the value of the VLOOKUP formula find its result. The VLOOKUP formula is:

    =VLOOKUP(A3,Wallplanner!A:AL,MATCH(TRUE,INDEX(Wallplanner!$B3:$AL3<>"",0),0)+1,FALSE)

    Any help/guidance appreciated.
    Tony
    Reply With QuoteRegister To Reply
  2. 10-16-2013, 08:26 AM #2
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Find Cell Address of a value found using a VLOOKUP Formula

    can you upload sample workbook
    Reply With QuoteRegister To Reply
  3. 10-16-2013, 08:39 AM #3
    ARGK
    ARGK is offline
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Find Cell Address of a value found using a VLOOKUP Formula

    Hi
    Here is a sample copy.
    Thanks
    Tony
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 10-16-2013, 08:46 AM #4
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Find Cell Address of a value found using a VLOOKUP Formula

    Tony

    Someone else is looking for exactly the same, or just you??

    http://www.excelforum.com/excel-form...-or-match.html
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  5. 10-16-2013, 08:48 AM #5
    ARGK
    ARGK is offline
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Find Cell Address of a value found using a VLOOKUP Formula

    Hi
    I am trying to find a solution for them but am stuck on part of the formula.
    Naturally nflsales will be given credit should we find a solution.
    Thanks
    Tony
    Reply With QuoteRegister To Reply
  6. 10-16-2013, 08:54 AM #6
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Find Cell Address of a value found using a VLOOKUP Formula

    Do you want the date that corresponds to 48w?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  7. 10-16-2013, 08:54 AM #7
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Find Cell Address of a value found using a VLOOKUP Formula

    I like to help and i'll try to do this..but in your other thread, because as a Moderator i have to say unfortunately that:


    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 : List of Cell Address for multiple data found
    By centurion210 in forum Excel General
    Replies: 7
    Last Post: 12-17-2009, 02:04 PM
  2. Vlookup to find the next occurance if the previous value has been found
    By adamkse in forum Excel General
    Replies: 1
    Last Post: 07-30-2009, 05:54 AM
  3. How to get the address of the cell found our by vlookup
    By dilettante in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2006, 10:10 PM
  4. Find text String and select cell address where it is found?
    By JCIrish in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-16-2006, 09:45 AM
  5. [SOLVED] cell address of occurence of a vlookup formula
    By [email protected] in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-26-2005, 02:05 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1