Lookup Not Functioning


#1

Having a bit of an issue and unsure how to resolve.

Have a table (Checkout) with a cell called “Availability”. The cell is a formula and it contains either a 0 or 1 depending on whether or not some other cells have value. (If Cell5=blank(),1,0 sort of thing)

In another table, I have a field with link to table Checkout. In another field, I have a rollup that looks at table Checkout, field “Availability” and should sum. Of course not all items have an entry in “Checkout”, but a few do, and those that do should have sums of one or greater as the Availability field has a 1 in it.

However, they all return back as zero. Was working the other day.

Any ideas? Thanks in advance.