VLOOKUP using range of dates

I have two tables:

Authorizations include a Start Date and an End Date, and an Auth Number.
Sessions includes a Session Date and a blank column for Auth Number.

How can I use VLOOKUP to find a matching Auth Number, using the Session Date to look up into the Authorizations table?
The logic needs to find an Auth Number in the Authorizations table where the Session Date is on or after the Start Date, AND the Session Date is on or before the End Date.

I'll code up an example if anyone needs it to see this clearly.

Thanks!

Here's an example worksheet.

Originally Posted by FlameRetired

Hello gdstuart. Welcome to the forum.

From where do you get 1538618597 in Manual Result cell H3?

If that is a 'typo' try this in G3 and fill down instead of VLOOKUP.

Formula:

Please Login or Register  to view this content.

It was a typo, pardon my slop.

There is one more specification. The Authorization table also contains a Patient ID. Authorizations are issued for each Patient. Authorization numbers are unique for each Patient ID (i.e. not repeated for a different Patient ID).

INDEX and MATCH are indeed working fine but now how can I incorporate the additional specification so the Authorization table is only queried for an auth that was issued to the specific Patient ID?

I updated the example to include this new spec.

Thanks so much for the prompt reply.