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.
=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.