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.