Lookup value with multiple condition

[HitarthShah]

hi i am trying to lookup a last months reading value with the filtration in date section with last month and other crieteria is house number in the same table. This application is used to see the consumption of the water in my residence area

FIND(MONTH(TODAY()-1),[DATE])

LOOKUP([HOUSE NUMBER], “READING”, “CURRENT READING”, “LAST READING”)