Link Formula from drop down

[p9j123]

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.

 

[Max1616]

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