Results 1 to 3 of 3

vLookup location based on link in adjacent cell

Threaded View

fischelr01 vLookup location based on... 05-12-2017, 11:28 AM
etaf Re: vLookup location based on... 05-12-2017, 11:42 AM
fischelr01 Re: vLookup location based on... 05-12-2017, 11:51 AM
  1. 05-12-2017, 11:51 AM #3
    fischelr01 is offline
    Registered User
    Join Date
    05-11-2017
    Location
    Atlanta
    MS-Off Ver
    10
    Posts
    8

    Re: vLookup location based on link in adjacent cell

    Thanks for the links, I will look into those. I've attached a screenshot of what I'm looking for. Please note, table_array has B1&C1. Idea is we can leave C1 constant, and just have to have the user drop-in a link to B1. Please note, I want to have the user link the entire file address in cell B1, i.e. 'V:/filepath1/filepath2/example.xls'

    Capture.JPG
    Attached Images Attached Images
    Last edited by fischelr01; 05-12-2017 at 11:54 AM.
    Reply With QuoteRegister To Reply
« 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. [SOLVED] creating a link from a set location to a location specified in another cell (googlemaps)
    By texcel_tom in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-26-2016, 09:48 AM
  2. vlookup location based on adjacent cell
    By oneillp1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-21-2016, 08:25 AM
  3. Formula to link HYPERLINK function to a different file location based on the workstation?
    By L_T in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-19-2016, 08:41 AM
  4. Vlookup formula on duplicates, then find max value in adjacent cell, return adjacent cell
    By comohelp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2015, 05:10 PM
  5. [SOLVED] Add Comment Based on adjacent cell value (vlookup?)
    By astinn in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-11-2015, 08:45 PM
  6. Associate / Link data based on location. Aka Conditional Row Copy
    By polican in forum Excel General
    Replies: 1
    Last Post: 02-20-2012, 07:47 PM
  7. Find Cell and Copy adjacent value to another location
    By JJalomo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2005, 04:06 PM

Tags for this Thread

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