Tratava-se de uma fórmula adequada: = LOOKUP (REVENUE_DOLLAR.D $ 1, REVENUE_DOMESTIC_CURRENCY.D $ 1: REVENUE_DOMESTIC_CURRENCY.AU $ 1, REVENUE_DOMESTIC_CURRENCY.D3: REVENUE_DOMESTIC_CURRENCY.AU3) * SUMIFS (EXCHANGE_RATES. $ D $ 2: EXCHANGE_RATES. $ D $ 10313 , EXCHANGE_RATES. $ C $ 2: EXCHANGE_RATES. $ C $ 10313, D $ 1, EXCHANGE_RATES. $ B $ 2: EXCHANGE_RATES. $ B $ 10313, $ B3)