How to get value from another table based on multiple criteria

Anonymous,

I am unsure about your expected result. When I use the following, I get the below results:

QuoteID1 = 
IF (
    AND (
        Shipments[Departure] >= RELATED ( Quotations[Start Date] ),
        Shipments[Departure] <= RELATED ( Quotations[Expiry Date] )
    ),
    LOOKUPVALUE (
        Quotations[QuoteID],
        Quotations[Branch], Shipments[Branch],
        Quotations[Department], Shipments[Department],
        Quotations[Local Client], Shipments[Local Client],
        Quotations[SrvLevel], Shipments[Srv Level],
        Quotations[Origin], Shipments[Origin],
        Quotations[Destination], Shipments[Destination]
    )
)

QuoteID2 = 
LOOKUPVALUE (
        Quotations[QuoteID],
        Quotations[Branch], Shipments[Branch],
        Quotations[Department], Shipments[Department],
        Quotations[Local Client], Shipments[Local Client],
        Quotations[SrvLevel], Shipments[Srv Level],
        Quotations[Origin], Shipments[Origin],
        Quotations[Destination], Shipments[Destination]
)

I am also unsure of performance as well.

Hello

I created following columns 

In Quotations table -

1. Concat = Quotations[Branch] & Quotations[Department] & Quotations[Local Client] & Quotations[SrvLevel] & Quotations[Origin] & Quotations[Destination]

In Shipments table -

1. Concat = Shipments[Branch] & Shipments[Department] & Shipments[Local Client] & Shipments[Srv Level] & Shipments[Origin] & Shipments[Destination]

2. QuoteID =
IF(ISBLANK(LOOKUPVALUE(Quotations[Branch],Quotations[Concat],Shipments[Concat])),"",
CALCULATE(VALUES(Quotations[QuoteID]),
FILTER(Quotations,Shipments[Departure]>Quotations[Start Date] && Shipments[Departure] < Quotations[Expiry Date]),FILTER(Quotations,Quotations[Concat]=Shipments[Concat]) )
)

You might have to play with QuoteID field a little to replace "greater than" or "less than" with appropriate "greater than or equal to" or "less than or equal to"

It gives me correct results otherwise -

Regards