Compare Columns Across Sheets
I'm trying to reconcile a bank statement with our Cash Flow log. I'm trying to compare a value on one sheet (the Cash Flow Log) with a range on the other (the bank statement sheet). If found, I'd like it to return "Yes" on my Cash Log sheet. I'm getting the Unparseable error message. I did insert the reference column. Here's what I have:
Can anyone assist?
Help Article Resources
Check out the Formula Handbook template!