I have two sheets:
- Contains form number and amount
- Contains bill number and amount
I tried to reconcile which bill belongs to which form using simple lookup based on the amount, ignoring duplicate amount and using the first value found.
After verification, this results in a static (no formula) reconciliation table, which will be updated as more form-bill get reconciled.
I created a column to check whether a form number has been reconciled.
Now, I want to update the bill table's lookup to exclude reconciled entries, so I put a condition to only lines entries with "#N/A".
But all of it returns N/A error!
How to fix this? I want to lookup for entries with matching amount AND has #N/A value.