+ Reply to Thread
Results 1 to 4 of 4

in Excel after VLookup how to go back find same item the one you link with Vlookup

  1. #1
    Forum Contributor
    Join Date
    01-31-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    124

    in Excel after VLookup how to go back find same item the one you link with Vlookup

    in excel 2010, after we do Vlook up, large file , is there a way to go and find the fasted way if you click to excel cell the one we link with Vlook up , it can show up where this info was link from, instead of
    searching from, because we have large file, if some one ask where this info came from , they want to see the detail , we have to go back that file and find that item .

    is there any easy way, where its Vlook up is link , there we can do something , it can take us back to same item and show the back up

    can some one answer this , I am not sure if my question is clear or not

    please let me know if its confusing


    thanks in advance

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: in Excel after VLookup how to go back find same item the one you link with Vlookup

    You can use Trace Precedents on the Formula's tab
    Arrows go from the cell used to the cell with the formula
    If the data source is on another sheet or in another book, it shows a small icon and a dotted line
    Double click on the dotted line to bring up the cells on the other sheets that were used
    Does that help?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Contributor
    Join Date
    01-31-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    124

    Re: in Excel after VLookup how to go back find same item the one you link with Vlookup

    thanks for reply ChemistB

    I am not familiar with Trace precedents, how can I find more info on this , how to use it,
    can you please advise

    thanks

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: in Excel after VLookup how to go back find same item the one you link with Vlookup

    This is a pretty good You tube on it

    https://www.youtube.com/watch?v=zGtfbk0rkw8

    Here's the Microsoft help on it

    https://support.office.com/en-in/art...c-21553d3e714d

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 12-26-2013, 01:12 PM
  2. [SOLVED] Stop Vlookup bringing back 0's or #REF! and bring back blanks instead
    By Carling73 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2013, 04:43 PM
  3. Replies: 2
    Last Post: 03-02-2012, 12:25 PM
  4. [SOLVED] Link cells in Access to Excel using VLOOKUP
    By dford in forum Excel General
    Replies: 3
    Last Post: 05-30-2006, 04:07 AM
  5. [SOLVED] Help with Click link, Find, Paste (Excel to Web back to Excel)
    By Steve in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2005, 04:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1