I am trying to do a Lookup in Sheet A of the latest value captured in Sheet B. The information I am looking up in Sheet B is a specific Bill Title (Title 4) associated with a Payer (Payer 2). The column that I have in common with both sheets is the Payer ID.
Since each Payer can have multiple bills, the current Lookup (and Relation) result in multiple bill titles being captured (Title 2, Title 7, Title 4).
The data in Sheet A is captured via a details page and the data in Sheet B was captured via a Form.
I am looking for a way to:
- List and display all the bills associated with Payer 2
- Isolate and display the latest bill by itself
I would appreciate any suggestion anybody might have on how to best do this.