Link Formula from drop down

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Link Formula from drop down

  1. #1
    Board Regular
    Join Date
    Apr 2014
    Posts
    201
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Link Formula from drop down

     
    Need help on the following, currently the formula is fixed ot File 1.xlsx (in red below)

    =IF(COUNTIF('T:\Version 10\[File 1.xlsx]Database'!$P:$P,D1)>0,"YES","NO")

    is it possible to change it to cell? let say D1 (D1 is Dropdown)

    Something like this:

    =IF(COUNTIF('T:\Version 10\[&D1&]Database'!$P:$P,D1)>0,"YES","NO") so that the formula will be based on the value of D1.
    Always be GOOD.....
    If you can't be GOOD, be CAREFUL....

  2. #2
    Board Regular
    Join Date
    Nov 2015
    Location
    United States: Portland, OR
    Posts
    366
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Link Formula from drop down

      
    Try this:
    =IF(COUNTIF(INDIRECT("'T:\Version 10\[" & D1 & "]Database'!$P:$P",TRUE),D1)>0,"YES","NO")

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com