i need help creating a formula to do a lookup, on my landing page i have an identifier for a company, however on my data page there may be more than one record for that company that all have the same identifier with different start dates. i need a formula to bring in the last date associated with that record. for example
Landing page
<tbody>
</tbody>
Data Page
<tbody>
</tbody>
on my landing page i want to be able to pull in that 12/31/2019 date for my end date
Landing page
Identifier | Company Name | End Date |
DHG1 | Northland Tool | |
<tbody>
</tbody>
Data Page
Identifer | Company Name | End Date |
DHG1 | Northland Tool | 2/28/2019 |
DHG1 | Northland Tool | 12/31/2019 |
<tbody>
</tbody>
on my landing page i want to be able to pull in that 12/31/2019 date for my end date