I am looking for some help with this formula ...
=IF(COUNTIF(D182,[Rental_Detail.xlsm]Rental_Data!$A:$A) >0, "YES","NO")"
D182 = 84351
This value does exist in workbook Rental_Detail.xlsm, worksheet Rental_Data, column A ... but the formula is wrongly saying it doesn't.