Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I am looking for some help with this formula ...
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.
Code:
=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.
Last edited: