<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Looking up a value in an excel file in dropbox. in Integrations</title>
    <link>https://www.dropboxforum.com/t5/Integrations/Looking-up-a-value-in-an-Excel-file-in-Dropbox/m-p/769543#M13111</link>
    <description>&lt;P&gt;each has their own user profile&lt;/P&gt;</description>
    <pubDate>Thu, 09 May 2024 14:46:59 GMT</pubDate>
    <dc:creator>donf13</dc:creator>
    <dc:date>2024-05-09T14:46:59Z</dc:date>
    <item>
      <title>Looking up a value in an Excel file in Dropbox.</title>
      <link>https://www.dropboxforum.com/t5/Integrations/Looking-up-a-value-in-an-Excel-file-in-Dropbox/m-p/769515#M13108</link>
      <description>&lt;P&gt;Our company has one excel file in dropbox and another file on my computer looks up a value from a column in the dropbox file.&amp;nbsp; Others need to use the file on my computer, so is there a way to change the link so it will work for everyone?&amp;nbsp;&amp;nbsp; current formula is VLOOKUP(A17,'C:\Users\myusername\Dropbox\foldernameindropbox\[filename.xlsx]worksheetname'!$G:$H,2,FALSE).&lt;/P&gt;</description>
      <pubDate>Thu, 09 May 2024 13:21:17 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Integrations/Looking-up-a-value-in-an-Excel-file-in-Dropbox/m-p/769515#M13108</guid>
      <dc:creator>donf13</dc:creator>
      <dc:date>2024-05-09T13:21:17Z</dc:date>
    </item>
    <item>
      <title>Re: Looking up a value in an excel file in dropbox.</title>
      <link>https://www.dropboxforum.com/t5/Integrations/Looking-up-a-value-in-an-Excel-file-in-Dropbox/m-p/769523#M13109</link>
      <description>&lt;P&gt;Hey &lt;SPAN style="color:var(--ck-color-mention-text);"&gt;&lt;SPAN style="background: var(--ck-color-mention-background); color: var(--ck-color-mention-text);"&gt;&lt;a href="https://www.dropboxforum.com/t5/user/viewprofilepage/user-id/1835260"&gt;@donf13&lt;/a&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;, I hope you're doing well!&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Just to make sure we're on the same page here: will the rest of the people be using a different user profile, or the same one?&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I'm assuming based on everything you mentioned, that they'd use different profiles, right?&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Let me know more, and we'll take it from there!&lt;/P&gt;</description>
      <pubDate>Thu, 09 May 2024 13:52:24 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Integrations/Looking-up-a-value-in-an-Excel-file-in-Dropbox/m-p/769523#M13109</guid>
      <dc:creator>Megan</dc:creator>
      <dc:date>2024-05-09T13:52:24Z</dc:date>
    </item>
    <item>
      <title>Re: Looking up a value in an Excel file in Dropbox.</title>
      <link>https://www.dropboxforum.com/t5/Integrations/Looking-up-a-value-in-an-Excel-file-in-Dropbox/m-p/769527#M13110</link>
      <description>&lt;BLOCKQUOTE&gt;&lt;HR /&gt;&lt;a href="https://www.dropboxforum.com/t5/user/viewprofilepage/user-id/1835260"&gt;@donf13&lt;/a&gt;&amp;nbsp;wrote:&lt;BR /&gt;
&lt;P&gt;Others need to use the file on my computer, so is there a way to change the link so it will work for everyone?&lt;/P&gt;
&lt;HR /&gt;&lt;/BLOCKQUOTE&gt;
&lt;P&gt;As you've discovered, Excel uses full paths when linking or referencing another file, and will not work with a relative path or an environment variable (such as %USERPROFILE%). The only solution would be to relocate the Dropbox folder for each user so that it's in a common location, such as C:\Dropbox, so everyone is using the same full path.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;You &lt;EM&gt;might&lt;/EM&gt; be able to set a custom variable using VBA, and then use that variable in the lookup path, but I've never tried that. Try Google for more information on that.&lt;/P&gt;</description>
      <pubDate>Thu, 09 May 2024 13:58:46 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Integrations/Looking-up-a-value-in-an-Excel-file-in-Dropbox/m-p/769527#M13110</guid>
      <dc:creator>Rich</dc:creator>
      <dc:date>2024-05-09T13:58:46Z</dc:date>
    </item>
    <item>
      <title>Re: Looking up a value in an excel file in dropbox.</title>
      <link>https://www.dropboxforum.com/t5/Integrations/Looking-up-a-value-in-an-Excel-file-in-Dropbox/m-p/769543#M13111</link>
      <description>&lt;P&gt;each has their own user profile&lt;/P&gt;</description>
      <pubDate>Thu, 09 May 2024 14:46:59 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Integrations/Looking-up-a-value-in-an-Excel-file-in-Dropbox/m-p/769543#M13111</guid>
      <dc:creator>donf13</dc:creator>
      <dc:date>2024-05-09T14:46:59Z</dc:date>
    </item>
  </channel>
</rss>

